Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help Clustered Bar Chart to show % Complete based on Filters

I think I have just been staring at this for too long and have worked myself into a corner.    So let's say I have the following data:   I have locations that get monthly utility usage numb...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I may have solved my own problem. 

     

    I added a conditional column with Yes/No for completed based off my criteria. (i.e. if  "" then "No", else "Yes")

     

    Added the following measure: 

    % YES =
    DIVIDE (
        CALCULATE ( COUNT ( Leadership_Usage_Tracking_v2[Completed] ), Leadership_Usage_Tracking_v2[Completed] = "YES" ),
        CALCULATE ( COUNT ( Leadership_Usage_Tracking_v2[Completed] ), ALLSELECTED ( Leadership_Usage_Tracking_v2[Completed] ) )
    )
     
    Seeing if this works. 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I provided a screenshot of the data table and the expected visual; should it be in a different format? 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Please post it as actual data (not an image) so we can copy and paste it into a PBIX file (and please include rows with Blank and N/A)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Done! I added it to the original post. Please let me know if it is enough.