The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Afternoon,
I have a table with Rows and Columns i need to try and have the total as a the same calucation the rows do.
So for example image below the total should be 57% not 42% at the moment i have summarise set to "average"
Solved! Go to Solution.
Hi, @sovereignauto ;
Based on my test, maybe it is better to use sum() to divide, and its total will be correct. I made a simple example and measured as follows:
sum = DIVIDE(SUM('Table'[value2]),SUM([value1]))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @sovereignauto ;
Based on my test, maybe it is better to use sum() to divide, and its total will be correct. I made a simple example and measured as follows:
sum = DIVIDE(SUM('Table'[value2]),SUM([value1]))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @sovereignauto
You can use sumx function to solve this.
I can write you the solution directly If you could provide sample .pbix file.
Regards
Kumail Raza
HI Kumail, i can use sumx in DAX but how would i get thsi to display as the total or do you "cover" the old total with a card or similar so it looks correct?
This is one of the blogs that you can refer
https://blog.enterprisedna.co/getting-totals-correct-when-using-advanced-logic/
I can also help you with the solution once .pbix file is available.
Regards
Kumail Raza
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |