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

That's the method I was thinking: create a new conditional column in Power Query to define "Complete" vs "Incomplete" and the use the column to filter the visual with a COUNT measure over CALCULATE([COUNT Measure], ALLSELECTED())

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It seems to be working the way I want it to so far! Now onto my next problem, haha. Thank you for your time!