Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |