I need your help for this situation. I hava a table (TABLE1) like this:
This table is related 1->* to another table (TABLE2), this one:
In this table, I have a measure called NumSurv = DISTINCTCOUNT(Table2[SURV]) that returns the number of answers to a questions. I show this model into a table visualization like this:
This visualization have a filter for the Id (only shows A1 and A4, the Id that exists in the Table1)
I want a measure that returns the total of the NumSurv, in this case, 5. I created a new measure called TotalSurv but the result is not correct when I put it in the table visualization:
TotalSurv = CALCULATE([NumSurv],ALLSELECTED(Table2[Name]))
This is how it's show:
And this I want it show:
What is the formula for the measure TotalSurv?
Go to Solution.
I found the solution!
The measure is:
TotalSurv = CALCULATE([NumSurv],ALLSELECTED(Table2))
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.