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
    )
Meeshe's avatar
Meeshe
Frequent Visitor
2 years ago

Apologies, I'd written it in a hurry and updated it now - thank you for your response.