Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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")
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
Solved! Go to 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") )
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.
@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") )
User | Count |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |