Forum Discussion

New Member

5 years ago

Solved

Multiple response and filters

I have a survey that generate 2 tables, one main table like this (Main): ID Year Country 1 2018 UK 2 2019 USA 3 2019 USA 4 2020 Germany 5 2020 USA 6 2018 German...

darpao
5 years ago
Finally I was able to find the solution.
Thank you ERD because your code helped me.

This is what I was looking for:

#Percentage = VAR main_id = CALCULATE(COUNTROWS('T-main'),REMOVEFILTERS('T-tech'[Technology]))
VAR tech_id = COUNT('T-tech'[ID])
VAR percentage = tech_id / main_id
RETURN
COALESCE(percentage,0)

Community Champion

5 years ago

I'm not sure what do you mean. You can check what you get by separating the measure:

#tech_id = CALCULATE(COUNT('T-tech'[ID]))

#main_id = COUNT('T-main'[ID])

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

New Member

5 years ago

Finally I was able to find the solution.

Thank you ERD because your code helped me.

This is what I was looking for:

#Percentage = VAR main_id = CALCULATE(COUNTROWS('T-main'),REMOVEFILTERS('T-tech'[Technology]))

VAR tech_id = COUNT('T-tech'[ID])

VAR percentage = tech_id / main_id

RETURN

COALESCE(percentage,0)