Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a new measure

Hi,   I'm kind a new to Power BI and want some help please. What I need to create is a measure where can calculate % of each Count Recvd/ Total Count Recvd (same as Expected Results column). I have...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Anonymous 

    It will be along these lines. 

    % of total =
DIVIDE (
    [CountPromoRecvd],
    CALCULATE ( [CountPromoRecvd], ALLSELECTED ( 'Data_Table'[Race] ) )
)

    You will have to change the name of the column in the ALLSELECTED to match your model.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

Anonymous 

It will be along these lines. 

% of total =
DIVIDE (
    [CountPromoRecvd],
    CALCULATE ( [CountPromoRecvd], ALLSELECTED ( 'Data_Table'[Race] ) )
)

You will have to change the name of the column in the ALLSELECTED to match your model.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much for your prompt action and help! This measure worked perfectly great!