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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
amandabus21
Helper V
Helper V

Row divided by Total

How can I get my rows to divide by my Total?

 

Example: 

amandabus21_0-1678128111671.png

 

The Distinct Count of Equipment (MP) column divided by the total 253. 

 

23/253

21/253, etc

1 ACCEPTED SOLUTION

AAA =
DIVIDE (
    COUNT(TABLENAME[Equipment (MP)]),
    CALCULATE (
        COUNT(TABLENAME[Equipment (MP)]),
        ALLSELECTED ()
    )
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
amandabus21
Helper V
Helper V

Hi, 

This isn't giving me the correct values.

 

first one should be 23/253 = .091

second should be21/253 = .830

 

amandabus21_0-1678130091281.png

 

AAA =
DIVIDE (
    COUNT(TABLENAME[Equipment (MP)]),
    CALCULATE (
        COUNT(TABLENAME[Equipment (MP)]),
        ALLSELECTED ()
    )
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Fowmy
Super User
Super User

@amandabus21 

Can try the following measure. You can also include the filed that in your table visual on the very left inside ALLSELECTED 

 

AAA =
DIVIDE (
    DISTINCTCOUNT(TABLENAME[Equipment (MP)]),
    CALCULATE (
        COUNT(TABLENAME[Equipment (MP)]),
        ALLSELECTED ()
    )
)
        

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.