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 October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!