Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I'm new and ran into this problem.
got this list (image 1) and report (image2) , I'd like to calculate difference of PM 10 (and PM2.5) between cities (guria and tbilisi) during the day. I marked blue line where I want data to be displayed. If it posibble to do, please help.
thanks in advance!
Solved! Go to Solution.
Hi @gkalandadze ,
Based on my test, you could refer to below measure:
Measure = var a =IF(CALCULATE(MAX('Table1'[Source]))="Tbilisi",CALCULATE(SUM('Table1'[Value]),'Table1'[Source]="Tbilisi")-CALCULATE(SUM('Table1'[Value]),'Table1'[Source]="Guria"),BLANK()) var b=DISTINCTCOUNT(Table1[Time]) return IF(b=1,BLANK(),a)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @gkalandadze ,
Based on my test, you could refer to below measure:
Measure = var a =IF(CALCULATE(MAX('Table1'[Source]))="Tbilisi",CALCULATE(SUM('Table1'[Value]),'Table1'[Source]="Tbilisi")-CALCULATE(SUM('Table1'[Value]),'Table1'[Source]="Guria"),BLANK()) var b=DISTINCTCOUNT(Table1[Time]) return IF(b=1,BLANK(),a)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks a lot!
Well, you should be able to turn on subtotals perhaps and then use something like Matrix Meassure Total Triple Threat Rock & Roll perhaps. https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |