Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi. I have water measurers latest values in table and lets say 10 devices. 3 are main measurers. that means that sum of thoes 3 measures should be qual to the sum of other 7 measurers values. there are 10 values, one for each device. how can i add thoes 3 and thoes 7 seperately and then compare them.
Solved! Go to Solution.
Hi @giorgilomidze,
You can create a measure below:
Measure = CALCULATE(SUM(Table1[Device Value]),FILTER(ALL(Table1),'Table1'[Device Level]=MAX(Table1[Device Level])))
For details, see attached pbix file.
Best Regards,
Qiuyun Yu
Hi @giorgilomidze,
Would you please use some dummy data to clarify the 10 measures? Also please explain the expected results.
Best Regards,
Qiuyun Yu
i need measure to show sum of values of first three Devices and measure to show sum of other 7 devices.
Hi @giorgilomidze,
You can create a measure below:
Measure = CALCULATE(SUM(Table1[Device Value]),FILTER(ALL(Table1),'Table1'[Device Level]=MAX(Table1[Device Level])))
For details, see attached pbix file.
Best Regards,
Qiuyun Yu
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
179 | |
86 | |
69 | |
63 | |
55 |