Forum Discussion
data for last N run ids
my data looks like this grade id, run id, timestamp, categoryid, measurevalue, speedvalue, i need to create a following measure, which will show all values for measurevalue with following co...
The final measure depends on your Matrix.
The Top 5 table can be calculated like this:
=
TOPN (
5,
CALCULATETABLE (
Data,
Data[categoryid] = "xyz",
Data[grade id] = "abc",
Data[speed value] > 150
),
Data[run id], DESC
)
LivioLanzo
Solution Sage
Solution SageThe final measure depends on your Matrix.
The Top 5 table can be calculated like this:
=
TOPN (
5,
CALCULATETABLE (
Data,
Data[categoryid] = "xyz",
Data[grade id] = "abc",
Data[speed value] > 150
),
Data[run id], DESC
)