Forum Discussion
KIMPD
8 years agoAdvocate II
Show last value in Cards
Hi, I have difficulties with the card visualisation. I have a datasets which only contains binary values 0 and 1 for a certain period. I have converted these values in 0 --> error and 1--> OK! b...
- 8 years ago
Hi KIMPD,
You can create a measure below, then put this measure in a card visual. For details, you can download attached pbix file.
Measure = var maxP=CALCULATE(MAX('Table1'[Period]),ALLSELECTED(Table1))
return
CALCULATE(MAX('Table1'[Status]),FILTER('Table1','Table1'[Period]=maxP))Best Regards,
Qiuyun Yu