Last answered:

28 Dec 2023

Posted on:

23 Dec 2023

0

HELLO ISSUE WITH THE %OF TOTAL SALES IT SHOWS ALL ASS 100%

Find attached all the DAXs i wrote them correctly according to the video , can you please tell me what is wrong 

7 answers ( 0 marked as helpful)
Instructor
Posted on:

24 Dec 2023

0

Can you please check that you have the correct relationship between fact_InternetSales and dim_SalesTerritory?

Posted on:

27 Dec 2023

0

 Hello , as you see it is as active many to one

Instructor
Posted on:

27 Dec 2023

0

Ok, any other filters applied on the page or slicers?

Posted on:

27 Dec 2023

0

no slicers are activated

Instructor
Posted on:

27 Dec 2023

0

there is something strange about the measure it says SUM of % Total Sales Amount, it is not supposed to apply any additional aggregations. You cannot sum percentages

Posted on:

28 Dec 2023

0

Yes it shouldn`t sounds like this it shouldn`t be the sum of % , i don`t know do you have any solution or i should just pass it. 

Instructor
Posted on:

28 Dec 2023

0

I don't think you are using the correct measure here, by default Power BI cannot apply additional aggregations on measures. Looks like you are possibly using a column here not a measure.

Submit an answer