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 matrix with the numerator (energy), the denominator (volume) with daily evolution tooltip for both and the ratio "Energy by volume" (tooltip non necessery).

 

Source variables : Day/Measure/Unit/Value

Calcultated Measure : 

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

Volume = CALCULATE(SUM(Energy_Volume[Value]),Energy_Volume[Measure]="Volume")
Energy_by_volume = DIVIDE(Energy_Volume[Energy],Energy_Volume[Volume])
 
Table 1 (with Value and the calculated ratio) : 

Table 2 with calculated measures 

 

In Table 1 my tooltip are good and in table 2 the are the sum of energy+Volume (bad). 

 

 

It's a shool exercice between line model (table 1 in the joined pbix) and measure model (table 2) but the tooltip is wrong. But no way is currently my need... Of course I don't want energy+volume but energy/volume

Please some help could be great.

Laurent

  • 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") )

2 Replies

  • 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") )

  • Thanks. It runs but I have to change my tooltip chart which was generic with "value" and it's now with every measure I need. Not perfect but I can do that.