Forum Discussion

ank47's avatar
ank47
New Member
4 years ago
Solved

Using Cards to show latest data without aggregation

I am using a dashboard to track latest data from "Sales" column. This "Sales" column is a measure of Whole number data type. Whenever i am trying to use it as a card it shows aggregation. I just want...
Data Protection
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    ank47 
    Incorporate this into your measure:

    TakeTheLatestAmount = 

var LatestDate = MAX(MEasure_First[Date])
var LatestValue = MAXX(FILTER(MEasure_First, MEasure_First[Date] = LatestDate), MEasure_First[Sales (Measure : Whole number)])

return LatestValue

     

vojtechsima's avatar
vojtechsima
Super User
4 years ago

ank47 
Incorporate this into your measure:

TakeTheLatestAmount = 

var LatestDate = MAX(MEasure_First[Date])
var LatestValue = MAXX(FILTER(MEasure_First, MEasure_First[Date] = LatestDate), MEasure_First[Sales (Measure : Whole number)])

return LatestValue