The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |