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 see attached hope it helps. you have to create a measure to assign the target and also added a card visual for %

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k 

I was too qiuck! It's working fine, but the problem now is that if I click on one Division, I want the target to also show per Division. I.e. for Div1, it should be 4 out of 18 instead of 4 out of total 72. And for two divisions, it should be "Nr of "Done" from 18x2, etc

Is it possible?

  • 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