Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have an issue with the following table I created in Power BI.
Why is the sum of Outer Square only calculated per Variant Code and not among all entries?
Solved! Go to Solution.
Ok, this simple measure did work:
Hi @Anonymous
If only the total sum is incorrect, other values in the [Outer Square] column is right, you could write a measure for a temparay solution.
Measure = IF(HASONEVALUE('value'[entry no]),MAX([outer square]),SUMX(ALL('value'),[outer square]))
To find why cause this problem, please provide detailed information, so i can reproduce your problem.
which table do the columns [entry no], [variant code], [outer square] from?
which are the key columns(create relationship based on) among three tables?
Best Regards
maggie
I didn't get it with a measure - but I can provide my pbix:
https://1drv.ms/u/s!Ai9Gkt_8r-5VlA4MEhngEGiiacPu
The issue is about the table on the bottom right side.
I added the quantity, so I don't have to many entries per variant code.
Ok, this simple measure did work:
That depends on whether Outer Square is a column or a measure. If it is a measure, see my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
I didn't work with measures yet. In this case it's just two tables connected through a third table:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |