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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
FARIDMD
Regular Visitor

Find the Count after filter is set

Hi,

 

I need assistance from expert to find the number of count after filter is set.

 

I have total count of name from a set of date range. For example from 8/11/2021 - 21/09/2023 i have 2595 count of name.

 

FARIDMD_0-1695973528375.png

 

Then i set the slicer, from 08/11/2021 - 31/7/2022 i have 412 count of names.

 

FARIDMD_1-1695973602491.png

 

How do I get the difference in count, Difference =2183. ( 2595 - 412) , in Dax and show in a card. 2183 will change everytime i adjus the slicer.

 

Thank you 🙂

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @FARIDMD ,

 

As ChiragGarg2512 mentioned above, Power BI won't store the snapshot value when you change the slicer.

I suggest you to create two unrelated Calendar table for two slicers.

vrzhoumsft_0-1696231668323.png

Then use USERELATIONSHIP() function. Measures:

 

Count of Name 1 = 
CALCULATE(COUNT('Table'[Name]),USERELATIONSHIP('Table'[Date],'Slicer 1'[Date]))
Count of Name 2 = 
CALCULATE(COUNT('Table'[Name]),USERELATIONSHIP('Table'[Date],'Slicer 2'[Date]))
Difference = [Count of Name 1] - [Count of Name 2]

 

Result is as below.

vrzhoumsft_5-1696231869711.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @FARIDMD ,

 

As ChiragGarg2512 mentioned above, Power BI won't store the snapshot value when you change the slicer.

I suggest you to create two unrelated Calendar table for two slicers.

vrzhoumsft_0-1696231668323.png

Then use USERELATIONSHIP() function. Measures:

 

Count of Name 1 = 
CALCULATE(COUNT('Table'[Name]),USERELATIONSHIP('Table'[Date],'Slicer 1'[Date]))
Count of Name 2 = 
CALCULATE(COUNT('Table'[Name]),USERELATIONSHIP('Table'[Date],'Slicer 2'[Date]))
Difference = [Count of Name 1] - [Count of Name 2]

 

Result is as below.

vrzhoumsft_5-1696231869711.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ChiragGarg2512
Solution Sage
Solution Sage

@FARIDMD , This will require two separate slicers, otherwise a snapshot value[value coming after a filter] cannot be stored. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.