Forum Discussion
Post PartisanSuitable visual help required
Hey harshadrokade ,
you can do something like that with a matrix:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi harshadrokade,
Are your expected output as follows:
You can try measure as:
Measure = CALCULATE( CONCATENATEX('Table',MAX('Table'[Student]),","), FILTER( 'Table', 'Table'[Score A\ScoreB]=MAX('Table'[Score A\ScoreB]) && 'Table'[Score B]=MAX('Table'[Score B]) ) )The pbix is attached.
If I have not understood your needs correctly, please reply to me.
Best Regards,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi harshadrokade,
Are your expected output as follows:
You can try measure as:
Measure =
CALCULATE(
CONCATENATEX('Table',MAX('Table'[Student]),","),
FILTER(
'Table',
'Table'[Score A\ScoreB]=MAX('Table'[Score A\ScoreB]) && 'Table'[Score B]=MAX('Table'[Score B])
)
)The pbix is attached.
If I have not understood your needs correctly, please reply to me.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Post PartisanThanks Sir. I shown the data in a card format & that was accepted by the boss. Thanks a lot for taking time out & helping me sir