Ratio Matrix Tooltip

[lhdp]

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]

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.

[amitchandak · Accepted solution]

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