Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
14 | |
13 | |
11 |