The last value with a date filter

[JulianOD]

Hi everybody!!

Thank you for your help .

The problem is this.

I have a table with different columns, what i want is that a multi row card can show me the count of   the last values of status aplying a month slicer.

For example:

So in a row card appliyng this filter (July)  it must show me 0 Active and in other row card must show me 3 Inactive (That is because i only want that count of the last status of  C1). And when I put in June it must show me 1 Active  and in the other row card 1 Inactive.

So in resume i want to follow the status of the ID and i want to know how many persons were active or inactive in each month.

[v-yuezhe-msft · Accepted solution]

@JulianOD,

Do you want to calculate cumulative count of inactive Id when you apply filter in Month slicer? If so, please create the following measures in your table.

Active = CALCULATE(COUNT(Table[Id]),FILTER(Table,Table[Status]="Active"))
Inactive = CALCULATE(COUNT(Table[Id]),FILTER(Table,Table[Status]="Inactive"))
Active count = IF(ISBLANK([Active]),0,[Active])
Inactive count = IF(ISBLANK([Inactive]),0,[Inactive])
sumInactive = CALCULATE([Inactive count],FILTER(ALL(Table),Table[Date]<=MAX(Table[Date])))

Then create the following multi-card row visual as follows.




Regards,

[JulianOD]

Thank you for your answer.

It helped me a lot.

But i need something more.  I already know how to count active and inactive.

But if i want to know the other data about this filter in other visualization i cant see them.

For example.

If i add a table because i want to know the ID or the Index of the data that i have filtered i cant see them.

Is there any method where i cant see all the data applying the same date-filter??

[v-yuezhe-msft]

@JulianOD ,

You can create another table visual to display the data, when you select value in the Month slicer, all the visuals will be filtered.



Regards,