Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Please help me with how to display the latest values in Card visualizations for all columns. I have created a card visual for all columns individually. If I select the 31st Mar date, the value does not display selected date value in all visuals.
Date | Inc | SR | Ch | Ct | Pr | Req | Inct% | Srs% | Att | Nor% | Count |
30/03/2020 | 0 | 0 | 0 | 0 | 8 | 132 | 6.50% | 1.67% | 0 | 100% | 0 |
31/03/2020 | 0 | 0 | 0 | 0 | 5 | 138 | 2.13% | 2.89% | 0 | 100% | 0 |
Solved! Go to Solution.
@Anonymous
Create Measure like this
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
Or Create a flag in your table as column
Flag Column=
var _max = maxx(Table,Table[Date])
return
If(Table[Date] =_max,1,0)
Use this to filter the data
@Anonymous
Create Measure like this
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
Or Create a flag in your table as column
Flag Column=
var _max = maxx(Table,Table[Date])
return
If(Table[Date] =_max,1,0)
Use this to filter the data
Hello, in your expression what value are you using as measure?
calculate([Measure],filter(Table,Table[Date] =_max))
Hi @amitchandak,
What do you mean by measure in your formula below?
Measure1 =
var _max = maxx(Table,Table[Date])
return
calculate([Measure],filter(Table,Table[Date] =_max))
I am trying to pull the progress for the latest date in the card visual. However am not getting how to get it.
Please help.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |