Forum Discussion
Count rows for column combinations
I need measure for Deliveries table , wich counts rows for each combination 'New, Modified, Repeat' (Type, in matrix as row) and 'Roof, Wall, Floor, Stair' (Design, in matrix as column) in each cell,...
amitchandak, thanks. I tried CALCULATE( COUNTROWS('Deliveries'), REMOVEFILTERS(Deliveries[Days]) ) (right table), but result the same as just with COUNTROWS('Deliveries') (left table). What I'm doing wrong?
Example of expected result