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. 
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Please share some sample, non-confidential data or a link to a PBIX file and a depiction of the expected output.

please include rows where Merge_Type is either a number, N/A, blank or 0 (as per your brief) to be able to provide a working solution.