Forum Discussion
IF Value > 0
Hi, I have the following table, I would like to get the distinct count as a query for TrackerID but when the durationconnected is greater than zero, then pick the TrackerID value for DurationCon...
Hi Anonymous
You could use DAX to change the data model.
Create a new table
Table =
FILTER (
SUMMARIZE (
ALL ( Sheet2 ),
[duration],
[id],
"rank", RANKX (
FILTER ( ALL ( Sheet2 ), [id] = EARLIER ( Sheet2[id] ) ),
[duration],
,
DESC,
DENSE
)
),
[rank] = 1
)Best Reagrds
Maggie
v-juanli-msft
Community Support
Community SupportHi Anonymous
You could use DAX to change the data model.
Create a new table
Table =
FILTER (
SUMMARIZE (
ALL ( Sheet2 ),
[duration],
[id],
"rank", RANKX (
FILTER ( ALL ( Sheet2 ), [id] = EARLIER ( Sheet2[id] ) ),
[duration],
,
DESC,
DENSE
)
),
[rank] = 1
)
Best Reagrds
Maggie