Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
This solution worked for me:
VAR SelectedDates = ALLSELECTED (table)
RETURN
CALCULATE (
COUNTROWS (table),
REMOVEFILTERS(),
VALUES(ftable[Date]),
SelectedDates
)
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
HELL OPLEASE TRY CALCULATE(Countrows(table),ALLSELECTED(table))
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |