Forum Discussion

Meeshe's avatar
Meeshe
Frequent Visitor
2 years ago
Solved

Countrows with removefilters not working as it should

I have the following DAX measure to display a row count figure on a card. There are two slicers, one for the Offer Date (using an all dates table) and one for the Status. When selecting a date range ...
DAX
REMOVEFILTERS
  • Meeshe's avatar
    Meeshe
    2 years ago

    Thank you for all your replies. I found the following DAX works, I don't know how....but it works!

     

      CALCULATE(
            CALCULATE(CountRows(AllocationOffersData),AllocationOffersData,Values(AllocationOffersData[Offer Date])), -- Calculates number of rows with the filter for Offer Date
            REMOVEFILTERS((AllocationOffersData[Offer Status]) -- Clears the filter for Status
    )
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Meeshe 

 

I added the date table as a slicer.

 

You can try the following measure:

countRows = CALCULATE(COUNT('Table'[ID]), FILTER(ALL('Table'), [OfferDate] >= MIN('Date'[Date]) && [OfferDate] <= MAX('Date'[Date])))

 

Is this the result you expect?

 

Best Regards,
Community Support Team _Yuliax

 

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

  • Meeshe's avatar
    Meeshe
    Frequent Visitor
    2 years ago

    Thank you so much. The dates would come from user input slicers. I did find some DAX that worked in the end:

     

      CALCULATE(
            CALCULATE(CountRows(AllocationOffersData),AllocationOffersData,Values(AllocationOffersData[Offer Date])), -- Calculates number of rows with the filter for Offer Date
            REMOVEFILTERS((AllocationOffersData[Offer Status]) -- Clears the filter for Status
    )