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 guys
looking for a dax,if i filter name "Punit" then the card should give '70' i.e, max for name.
name | totalmins |
punit | 30 |
punit | 50 |
punit | 70 |
punit | 10 |
bharat | 20 |
bharat | 20 |
bharat | 30 |
Solved! Go to Solution.
Hi, @jay_patel
I'm not sure you need to get the desired results in table or card visual, so I've provided some of the results you might expect.
Create a measure to use on the card:
max = MAX('Table'[totalmins])
Or you want to get the desired result on the table:
max for name =
CALCULATE ( MAX ( 'Table'[totalmins] ), ALLEXCEPT ( 'Table', 'Table'[name] ) )
You can choose the effect that suits you according to your preferences.
The sample effect is as follows:
Sample data:
Result:
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jay_patel
I'm not sure you need to get the desired results in table or card visual, so I've provided some of the results you might expect.
Create a measure to use on the card:
max = MAX('Table'[totalmins])
Or you want to get the desired result on the table:
max for name =
CALCULATE ( MAX ( 'Table'[totalmins] ), ALLEXCEPT ( 'Table', 'Table'[name] ) )
You can choose the effect that suits you according to your preferences.
The sample effect is as follows:
Sample data:
Result:
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jay_patel
I am not sure if I understood your question correctly, but please check the sample pbix file's link down below.
I think you can write the below measure.
Or, if I missed something, please let me know.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |