Resolved: Bug!! whith %sales
- When I add (% sales) it shows me this result, the whole column is result = 100
- And while adding the currency, the currency is repeated in the countries in this way
What's wrong here please!
- And while adding the currency, the currency is repeated in the countries in this way
What's wrong here please!
4 answers ( 1 marked as helpful)
show me your DAX, please
1-
2-
3-
Please remove SalesTerritoryCountry and your table should look ok. The issue comes that you are using ALL function on dim_Currency, but not on SalesTerritoryCountry.
Amazing it worked, thank you very much!