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

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, ank47 

 

Maybe you can just use measure to come up with the latest values.

Measure:

Latest = 
CALCULATE([Sales(Text)],FILTER(ALL('Table'),[Date]=MAX('Table'[Date])))

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.