Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
16 | |
13 | |
12 | |
11 | |
10 |
User | Count |
---|---|
19 | |
16 | |
15 | |
11 | |
9 |