Forum Discussion
Measure
Dear All,
I need your help, I have a measure of “Gross Revenue” which I am applying on a table (visual) alongwith a column of “Segment”. It is showing results properly. I have also made a measure to get lowest revenue by segment successfully using MinX DAX.
But problem is that I need another measure to get the name of that segment where gross revenue is lowest.
For highest gross revenue, I have used RankX DAX and to get name of segment with highest gross revenue I have used FirstNonBlank. But in case of lowest gross revenue FirstNonBlank is not working.
Regards
4 Replies
Hi faisalshafi
If I understand you correctly,
The answer to the question in the link may be helpful.
https://community.powerbi.com/t5/Desktop/Return-a-category-name-associated-with-a-minimum-value/td-p/2161424
Please upload a file with your example and the desired result if not.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I have tried the referred reply with some modification but I could not get the result. Actually, in my case Gross Revenue is a measure which is based on another table, however, Gross Revenue is not a column therefore I think I need different solution.
However, thanks for your response.
Would you be able to share a file with an example so that I can better understand the requirements?
