Forum Discussion

KIMPD's avatar
KIMPD
Advocate II
8 years ago
Solved

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...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    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