How to Count records and partition by a column

[databot_kd]

Hi Community, 

I am trying to do a count partitioned by date and area as shown below:

Currently using a formula to get the count selected:
CountSelected = CALCULATE(Count(table[rows]), ALLSELECTED(table))

I have tried using ALLEXCEPT function which somewhat works but that ignores my slicer selection unless im using it wrong. 

Thanks in advance 

[databot_kd]

This solution worked for me:

VAR SelectedDates = ALLSELECTED (table)
RETURN
CALCULATE (
COUNTROWS (table),
REMOVEFILTERS(),
VALUES(ftable[Date]),
SelectedDates
)

[v-cgao-msft · Accepted solution]

Hi @databot_kd ,

Please try this measure.

CountSelected = 
CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table','Table'[Date],'Table'[Area]),
    VALUES('Table'[Room])
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[annonymous1999]

HELL OPLEASE TRY CALCULATE(Countrows(table),ALLSELECTED(table))