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
Hoping
Helper III
Helper III

Include all visual and page level filters in DAX Measure

I am unable to include Page level filters in the DAX Measure that calculates cumulative total for each year.

 

Measure 1:
APP_COUNT = DISTINCTCOUNT('Table'[APP_ID])
 
Measure 2:
CUM_COUNT = CALCULATE (
    [APP_COUNT],
    FILTER(
        ALLSELECTED('Table'),
        YEAR('Table'[Recvd_Date(New)]) = MAX('Table'[Recvd Year])
        && 'Table'[Recvd_Date(New)] <= MAX( ('Table'[Recvd_Date(New)])
        )
)
)
 
There are several page level filters but the Measure 2 is not including the page level filters.
 
However Measure 1 includes the page level filters.
 
Measure 2 is a cumulative count of Measure 1.
 
Jan 2023, Jan2023+Feb2023, Jan2023+Feb2023+March2023 etc.
 
Measure 2 numbers are correct as it is, but does not include any page level filters in the calculation.
 
If I remove all page level filters, the numbers match perfectly between Measure 1 and 2.
 
How can I make sure all slicers and page level filters are included in Measure 2 calculation?
 
2 REPLIES 2
Anonymous
Not applicable

Hi @Hoping ,

 

Please share a sample file with us and show us a screenshot with the result you want. This will make it easier for us to find the solution.

 

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.

devanshi
Helper V
Helper V

I think your measure is right there is minor mistake in measure 2 you have not written (New) in filter condition.
So, it will confuse during the condition checking.

If above will giving the error then try this:

CUM_COUNT = CALCULATE ([APP_COUNT],
                                     FILTER(ALLSELECTED('Table'), 'Table'[Recvd_Date(New)] <= MAX( ('Table'[Recvd_Date(New)])
                                                  )
                                   )
)

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.