Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, i have lots of tachometers in my project with no issue, then I get into this.
%_Practicas has a value as shown in the card, but the tachometer shows it as empty:
%_Practicas is a measure calculated by weighting another % measures as in:
%_Practicas = %_measure1 * 0.5 + %_measure2 * 0.5
I get %_measure1 dividing the last record (Actual) of a Attribute against the max possible value in another table as in:
%_measure1= DIVIDE(
SUMX(
FILTER(measure1;
AND(measure1[ACTUAL]="ACTUAL";measure1[Attribute]="Attribute1")
);measure1[Value])
; SUMX(
FILTER(indicadores_limites;
indicadores_limites[Indicador]="Attribute1"
);indicadores_limites[% max])
)
2 hours after trying a lot of things like copy a functional tachometer, converting unit types, etc, I come here, hope you can help me!
Thank you!
Solved! Go to Solution.
I went with the simple solution, the table Im referencing to has no more than 20 rows, so I duplicate it and use the first for calculations and the seccond to user in tachometers and other elements that only need the value.
Thank you!
Hi @Anonymous,
Is it the Tachometer in the bottom of the snapshot? Can you share the file? You can mask the data first. The measure seems fine.
Best Regards,
Dale
Ok, I think I found the problem buy don't understand why is this hapening:
The limits for the Tachometer are also in "indicadores limites", there I have the values for all the attributes I'm using.
I add the measure %_Practicas to the tachometer with the values on "indicadores limites":
% max, %_target, %_range2, %_range3
because I have a lot of ranges in that table I filter the table by "Practicas" to get the limits I need for this measure.
Now the problem, for some reason when I filter by "indicadores limites" in the Tachometer %_measure1 gets filtered, so %_Practicas receibe the filtered results (blank).
So I need that those formulas doesn't get filtered at "visual level filter"
Any idea how can I solve this? hope you understand
Thank you!
Hi @Anonymous,
I'm afraid we can't remove the effects of Visual Level Filter. Because it filters the visual directly unless that filter doesn't in the visual. Can you use a slicer instead? Can you share the file? You can mask the sensitive data first.
Best Regards,
Dale
I went with the simple solution, the table Im referencing to has no more than 20 rows, so I duplicate it and use the first for calculations and the seccond to user in tachometers and other elements that only need the value.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |