Help with Count of row context

[yve214]

Hi there,

I have this measure below that gives me a count in a row context that I need. But I am unable to put it in a card as a value. WHat am i doing wrong, please can someone help me with how to tweak the measure?

var _max0 = maxx(filter(allselected(Table), Table[Emp_id] = max(Table[Emp_id]) && Table[Interval] =0),Table[Effective_Date])
var _max5 = maxx(filter(allselected(Table), Table[Emp_id] = max(Table[Emp_id]) && Table[Interval] =5),Table[Effective_Date])
return
calculate(distinctcount(table[emp_ID]), filter(Table, Table[Interval] =5 && _max5>_max0))

Expected Results:

a sorecard value of 1

ID	Emp_ID	Interval	Effective_Date	Score
2	1001	0	8/26/2020	3.3
6	1002	0	1/1/2022	2.0
3	1001	3	11/20/2020	3.5
5	1001	5	2/1/2021	4.1

[ValtteriN · Accepted solution]

Hi,

You can achieve this with additional measure like this:

card measure = SUMX('Table',[your measure])

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[yve214]

Thank you very much