Forum Discussion
spaceman127
Super User
Super UserQuestion about Power Bi Dekstop incorrect total value
Hello Community, I have a question and a problem with my calculation when I filter The total values are unfortunately not correct. Cost should be 20314,20 Euro and costaggretierteuro...
Hi spaceman127 ,
You can create another two measures as below to get it:
Sum of Cost= SUM('facttable1'[cost])New_sumofcost=sumx(values('dimAzTags'[Valuename]),[Sum of Cost])Sum of costaggregierteuro= SUM('facttable1'[costaggregierteuro])New_sumofcostagg=sumx(values('dimAzTags'[Valuename]),[Sum of costaggregierteuro])In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards
Hi spaceman127 ,
You can create another two measures as below to get it:
Sum of Cost= SUM('facttable1'[cost])New_sumofcost=sumx(values('dimAzTags'[Valuename]),[Sum of Cost])
Sum of costaggregierteuro= SUM('facttable1'[costaggregierteuro])New_sumofcostagg=sumx(values('dimAzTags'[Valuename]),[Sum of costaggregierteuro])In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards
spaceman127Super User
Super UserHi,
Thank you for your help.
This is the solution to my problem.
Best Regards