Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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,
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,
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??
@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,
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |