Forum Discussion

Jeeo's avatar
Jeeo
Regular Visitor
8 years ago

Display Last Score in a Card

I'm struggling with the DAX to achieve what looks like a simple objective.  We're keeping a simple log of report values.  I'm wishing to display a Card Visual of the Score for the Last Report Date for each KPI type.  For example, I would like one card to display Revenue Growth 10%; the last known score for Revenue Growth, recorded on November 1st.  Whatever logic or DAX is involved, I can replicate for the other KPI's.  Thanks so much.

 

 

 

2 Replies

  • ccakjcrx's avatar
    ccakjcrx
    Icon for Resolver I rankResolver I
    8 years ago

    Hey Jeeo!

     

    I was able to use the following measure, and attach it to a card visual to return the latest revenue number:

     

    CALCULATE(
    SUM(Sheet1[Score]),
    FILTER(
        Sheet1,
        Sheet1[Report Date] = MAX(Sheet1[Report Date])
    ),
    FILTER(
        Sheet1,
        Sheet1[KPI] = "Revenue Growth"
    )
)

     Here is a screenshot of PBI Desktop:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Click HERE to access my .pbix file.

     

    Hope this helps!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Try this measure.

     

    =LOOKUPVALUE(Sheet1[Score],Sheet1[Report Date],MAX(Sheet1[Report Date]),Sheet1[KPI],VALUES(Sheet1[KPI]))

     

    Hope this helps.