Forum Discussion

lhdp's avatar
lhdp
Helper I
4 years ago
Solved

Ratio Matrix Tooltip

My need is relativly simple :  - My model is based on lines with a key day/measure/value with differents type of measure (in my example : Energy Consumption & Volume of water pumped) - I want a mat...
  • amitchandak's avatar
    4 years ago

    lhdp, It is not very clear, What is wrong with tooltip

    You can try like

     

    Energy = CALCULATE(SUM(Energy_Volume[Value]),Filter( Energy_Volume, Energy_Volume[Measure]="Energy"))

     

    Volume = CALCULATE(SUM(Energy_Volume[Value]),Filter( Energy_Volume, Energy_Volume[Measure]="Volume") )