Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created this Measure statement:
Generated Energy (KWH) = CALCULATE(max(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH") - CALCULATE(min(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH")
But also I need to add grouping to this Measure "Generated Energy (KWH)" to be calculated Group by Specific Field
Solved! Go to Solution.
Hi @dezzat,
I need to add grouping to this Measure "Generated Energy (KWH)" to be calculated Group by Specific Field
try this:
Generated Energy (KWH) = CALCULATE(( CALCULATE(max(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH") - CALCULATE(min(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH") ); //your calculation ALLEXCEPT(Readings;Readings[Specific_Field]) // Group field )//top level calculate
... and Merry Christmas.
Best regs
Hi @dezzat,
I need to add grouping to this Measure "Generated Energy (KWH)" to be calculated Group by Specific Field
try this:
Generated Energy (KWH) = CALCULATE(( CALCULATE(max(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH") - CALCULATE(min(Readings[Reading]),Readings[Measurement Point Description]="Generated KWH") ); //your calculation ALLEXCEPT(Readings;Readings[Specific_Field]) // Group field )//top level calculate
... and Merry Christmas.
Best regs
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |