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 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).