Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Gauge chart - doubles data in total

Hi All I need to create a KPI dashboard where I calculate two KPI's (power BI file and Excel attached): 1) % of "Done" workshops per division 2) % of "Done" reviews per division   I have two que...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous see attached hope it helps. you have to create a measure to assign the target and also added a card visual for %

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous change you target measure to

 

Target = 
CALCULATE( 
COUNTROWS( Table13 ), 
ALLEXCEPT( Table13, Table13[Divusion] ) 
)

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k

thank you! And sorry if I'm asking easy questions, I just started in PB...

it works now, but if there're no entries (i.e. all "N/A"), then the target is "blank" - any chance it can be fixed?

(I have a filter on status, if it makes any difference)

 

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous what you want the target in that case? If you want target to be zero, add 0 to the target measure

     

    Target = CALCULATE( COUNTROWS( Table13 ), ALLEXCEPT( Table13, Table13[Divusion] ) ) + 0
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k

      hi Parry, 0 won't work because the target should be 36 if no division is selected and 9 if one division is selected (independent of whether it has anything "Done" or not, as it's the total number of workshops/reviews in each separate division).