Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

AllisonKennedy   I created the measure count of floor ( COUNTA('public facilities'[name]) ).  I am still not geting the floors to total up.  If you look at the first one there is 2 garages with 6 floors each.  I am needing it to be North Garage 6 floors and West Garage 6 Floors.

 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

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]))