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
I am not great on DAX and may have made it more complicated than it needs to be. So this may be a simple answer for the experts here. I am away for a few days and will reply when back in the office to any questions.
I have ranking of tickets closed by users within their team (Assignment Group).
What I am trying to setup using a Power Automate button is an email that sends an individual email to each team member.
It tells them the total tickets they closed, their ranking based on the tickets they closed and what the lowest rank value was for the team. I can't just count the number of team members due to duplicate rankings, I'm using "Dense" in the ranking measure.
When sending the emails the lowest rank which should be 7 ends up being a 1.
Example of email output received.
Changes
5
You ranked 4
Lowest rank is 1 (this value should be 7)
SNOW Changes 5
Other Changes 0
Dax measures and dax column formulas used are below.
Below is the measure that gives me the lowest rank value. I am thinking this may need some more work?
Thanks in advance with any help.
Solved! Go to Solution.
LowestRankMeasure = calculate(MAX(Table[Changes Rank]), allselected())
Does this work?
Or maxx
Thanks very much for your help PurpleGate. It worked with MAXX, code below. So simple when looking at it 🙂 now.
LowestRankMeasure = calculate(MAX(Table[Changes Rank]), allselected())
Does this work?
Or maxx
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |