Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 created below measure but it gave me %  Rcvd instead, what should I do to get the same results as Excpected Results column?

 

 

%PromoRecvd = 
DIVIDE([CountPromoRecvd], COUNT('Data_Table'[Employee ID]))

 

 

 Count EECount Recvd% RcvdExpected Results
Race A1715.9%2.7%
Race B28414.3%10.8%
Race C5958.5%13.5%
Race D2372711.4%73.0%
 34137  

 

Thank you

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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

View solution in original post

6 REPLIES 6
ponnusamy
Solution Supplier
Solution Supplier

Try this..

ponnusamy_0-1631136596008.png

 

Anonymous
Not applicable

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

@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
Not applicable

Thank you so much!

jdbuchanan71
Super User
Super User

@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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.