Tachometer not showing Value

[Anonymous]

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!

[v-jiascu-msft]

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

[Anonymous]

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!

[v-jiascu-msft]

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

[Anonymous · Accepted 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!

[Anonymous]

Hi, didn't understand what you mean with "Is it the Tachometer in the bottom of the snapshot?".
I'll see how to mask the data to share the file, all info come from SQL.
Thank you!