Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
dstead0610
Regular Visitor

ignore row context, count ALL dates inside slicer filter

hello,

i need to count all individual days inside date slicer, while ignoring the row context. Without it, it works fine:

slicer, measure "countDays" is correctslicer, measure "countDays" is correct

 

but with a row context, the number of individual days (SAME MEASURE), is wrong:

the row conext is not counting the individual dates where there was no booking on this type of roomthe row conext is not counting the individual dates where there was no booking on this type of room

 

1 REPLY 1
Greg_Deckler
Super User
Super User

Would need to supply some sample data and the formula of the measure.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.