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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much for your help. I tried your measure but was not able to find "Count Recievded" when I was trying to write the measure (exactly after I was writing the SUM).

ponnusamy's avatar
ponnusamy
Icon for Solution Supplier rankSolution Supplier
5 years ago

Anonymous :  "Count Recievded" was the name of the column in my data source I created for testing the solution. You should have replaced that with "CountPromoRecvd". Happy to see your issue resolved.

 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much!