topic Re: How to Count records and partition by a column in DAX Commands and Tips

How to Count records and partition by a column

databot_kd — Fri, 28 Apr 2023 08:18:52 GMT

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

Re: How to Count records and partition by a column

eliasayyy — Fri, 28 Apr 2023 09:07:03 GMT

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

Re: How to Count records and partition by a column

Anonymous — Wed, 03 May 2023 05:45:51 GMT

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

Re: How to Count records and partition by a column

databot_kd — Fri, 05 May 2023 03:10:02 GMT

This solution worked for me:

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