Forum Discussion
Advocate ISSAS - Dimension does not aggregate in Power BI Desktop
Hello v-juanli-msft ,
the measure is defined by DAX (sum) in SSAS but its not the problem here. In the meantime I got a solution. The problem was the set sorting of Month and Year. It was sorted by day_ID, which meant that although the day is not on the report, each item is still calculated separately by day. I have now arranged the sort on the basis of fields of the same level, which solved the problem.
Nevertheless thanks for your will to help
Community SupportHi Xriz
Is the "sum_CO_IST" measure created in Power BI or in SSAS?
How do you define it with DAX or MDX?
Best Regards
Maggie
- Xriz
Hello v-juanli-msft ,
the measure is defined by DAX (sum) in SSAS but its not the problem here. In the meantime I got a solution. The problem was the set sorting of Month and Year. It was sorted by day_ID, which meant that although the day is not on the report, each item is still calculated separately by day. I have now arranged the sort on the basis of fields of the same level, which solved the problem.
Nevertheless thanks for your will to help