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.
Hello everyone, I am stuck in a scenario.
I have made a table visual with Employee Name(Which is a column from a table) and Utilization Rate(which is a calculated measure). As given below :
Employee Name | Utilization Rate |
a | 100.00% |
b | 100.00% |
c | 100.00% |
c | 0.00% |
d | 35.71% |
e | 0.00% |
e | 0.00% |
e | 0.00% |
f | 72.62% |
f | 70.24% |
g | 100.00% |
From this table visual I want to remove the duplicated employee names. I want to keep only those rows with the highest Utilization Rate as shown below :
Employee Name | Utilization Rate |
a | 100.00% |
b | 100.00% |
c | 100.00% |
d | 35.71% |
e | 0.00% |
f | 72.62% |
g | 100.00% |
Here I want to remove the rows in red colour. As shown in the immage below :
Can anyone help me solve this problem?
Solved! Go to Solution.
HI @Aditya_Meshram,
You can try to use the following measure to get the max Utilization Rate based on the current employee group:
Measure =
VAR cEName =
VALUES ( 'Table'[Employee Name] )
RETURN
MAXX (
FILTER (
SUMMARIZE (
'Table',
'Table'[Employee Name],
"mURate", MAX ( 'Table'[Utilization Rate] )
),
[Employee Name] IN cEName
),
[mURate]
)
Regards,
Xiaoxin Sheng
You even don't need an explicit measure to achieve this,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL thanks for your input
But since Uilization Rate is a measure I'm not getting these options.
Regards,
Aditya
@Aditya_Meshram You can create a calculated table as:
HI @Aditya_Meshram,
You can try to use the following measure to get the max Utilization Rate based on the current employee group:
Measure =
VAR cEName =
VALUES ( 'Table'[Employee Name] )
RETURN
MAXX (
FILTER (
SUMMARIZE (
'Table',
'Table'[Employee Name],
"mURate", MAX ( 'Table'[Utilization Rate] )
),
[Employee Name] IN cEName
),
[mURate]
)
Regards,
Xiaoxin Sheng
Hi @BeaBF ,
since Utilization Rate is a measure,
I'm not getting the option to aggregate it.
Anyways, thanks for your input.
Aditya
Hi @Aditya_Meshram , we would need more details about the Data Model and DAX Measures to provide a clear solution. It is likely that Many to One or equivalent is causing the issue. But I am wondering if you have the following situation occuring. How to show a name more than once in Power BI - YouTube
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 |
---|---|
46 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |