Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

RemoveFilter Function Not Working Within Calculate when Last.Date is used as a Filter

Hi All,    I've simplified my Data/Measure and attached a screenshot.   The Formula within my Measure is as follows:    CountRows for LastDate = CALCULATE(COUNTROWS(Sheet1),LASTDATE(Sheet1[Dat...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Try like

 

CountRows for LastDate =
Var _max = maxx(allselected(sheet1), Sheet1[Date])
return
CALCULATE(COUNTROWS(Sheet1),filter(Sheet1, Sheet1[Date]= _max))

 

OR

 

CountRows for LastDate =
Var _max = maxx(all(sheet1), Sheet1[Date])
return
CALCULATE(COUNTROWS(Sheet1),Sheet1[Date]= _max)

 

 

refer if needed

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e