Forum Discussion
Solved
Nested DAX query with filter conditions
Hi there, I am fairly new to DAX, I would really appreciate your assistance, please. I am trying to filter out the number of customers that belong to both zones. The table looks like this: Table...
hi DanVelus ,
I try to understand the model you are talking about and hope to get the result you want in the end.
Please create two new table as follows firstly:
Then, create a measure:
Result should look like this:
You can also create a new measure as follows:
Result should look like this:
Hope it helps!
Best regards,
Community Support Team CGao
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
New Measure=COUNTROWS(FILTER(VALUES('Table'[Customer_id]),CALCULATE(COUNTROWS(FILTER({"A","B"},[Value] IN VALUES('Table'[Zone_id]))))=2))