Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |