Forum Discussion
count ifs
I am trying to count the number of floors per building per facility. I am using two measures to get this but it is not working Facility Count = COUNTROWS('public facilities') CALCULATE('Measure...
Anonymous This is because you have [Floor] still in the table. A couple of things you can do, either use a matrix visual instead to get the subtotals;
[Count of Floors] in Values
[Facility] in Rows
[Building] in Rows
[Floor] in Rows
Expand down to all levels using the double connected arrows (looks like a fork kind of) at top of matrix.
or update your measure:
Count of All Floors = CALCULATE(COUNTA('public facilities'[name]) , ALL('public facilities'[floor]))
Anonymous ,
Have you tried DISTINCTCOUNT('public facilities'[name]) ?