topic Re: Help with Count of row context in DAX Commands and Tips

Help with Count of row context

yve214 — Wed, 02 Feb 2022 14:05:30 GMT

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

Re: Help with Count of row context

ValtteriN — Wed, 02 Feb 2022 15:43:26 GMT

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/

Re: Help with Count of row context

yve214 — Wed, 09 Feb 2022 23:11:18 GMT

Thank you very much