Forum Discussion

Helper III

6 years ago

Solved

Calculating a measure

Hi I have created 2 measures that give me a MAX of a energy column and a MIN of a energy column by row by date. When I create a measure that is MAX enery - MIin energy, this works greate at row level...

jdbuchanan71
6 years ago
Hello PSRai

Take a look at this post. It discusses the issue you are working on and give a solution.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
v-chuncz-msft
6 years ago
PSRai

Take a look at ISINSCOPE as well.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947

https://community.powerbi.com/t5/Desktop/Hide-matrix-rows-without-affecting-values/m-p/646134#M309686

Super User

6 years ago

Hello PSRai

Take a look at this post. It discusses the issue you are working on and give a solution.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907