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
DataPeter
Frequent Visitor

DistinctCount as a Percentage of Total

Hey All

 

Doing my head in with this one. I am trying to calculuate the DistinctCount as a percentage of total rows.  The below calculation allows me identify the count, however I cant workout how to then calculate it as a percentage of 1660 (total rows).  Any help would be really appreciated. 

 

CALCULATE(
DISTINCTCOUNT('Survey Data 18 May 2021'[Response ID]),
'Survey Data 18 May 2021'[What are the three main motivations for you to go caravan and camping? - To reconnect with nature] = "To reconnect with nature")

 

cheers

1 REPLY 1
Fowmy
Super User
Super User

@DataPeter 

Can you try the following measure and let me know if you are getting the desired results?

teste =
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT('Survey Data 18 May 2021'[Response ID]),
        'Survey Data 18 May 2021'[What are the three main motivations for you to go caravan and camping? - To reconnect with nature] = "To reconnect with nature"
    ),
    COUNT('Survey Data 18 May 2021'[Response ID])
)

 

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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.