Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Tachometer not showing Value

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!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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!

5 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago
      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!
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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