Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Hi,
You can achieve this with additional measure like this:
Proud to be a Super User!
Hi,
You can achieve this with additional measure like this:
Proud to be a Super User!
Thank you very much
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |