cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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

1 ACCEPTED SOLUTION
Super User

@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 2
Helper I

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.

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors