Last answered:

17 Apr 2024

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 

8 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.

Posted on:

17 Apr 2024

0

Your formula of %ofTotalSalesAmount should be equal to :

%ofTotalSalesAmount = Divide(Amesures[TotalSalesAmount], Calculate(SUM(fact_InternetSales[SalesAmount], All (dim_SalesTerritory[SalesTerritoryCountry]), All (dim_SalesTerritory[CountryOrder])))*100


Instead of

%ofTotalSalesAmount = Divide(Amesures[TotalSalesAmount], Calculate(SUM(fact_InternetSales[SalesAmount], All (dim_SalesTerritory[SalesTerritoryCountry]), All (dim_SalesTerritory[CountryOrder]))*100)


It will solve your problem I guess!

Submit an answer