Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have a table with a "Person" Column and next to them a value for their "Total Pay". I would like to show the person who has the lowest pay on a card within a report or dashboard. How would one go about finding the lowest value in "Total Pay" and then print the "Person"'s name on the card?
Thank you in advance,
Maksim Richards
Solved! Go to Solution.
Since you want to display the person with lowest value in the card, we can't directly get the name text via calcualted measure. For your requrement, I suggest you create another calculated table which only filters the lowest person row.
Lowest Pay = TOPN(1,Table9,Table9[Total Pay],ASC)
Regards,
Since you want to display the person with lowest value in the card, we can't directly get the name text via calcualted measure. For your requrement, I suggest you create another calculated table which only filters the lowest person row.
Lowest Pay = TOPN(1,Table9,Table9[Total Pay],ASC)
Regards,
Thank you so much, that worked brilliantly.
Thanks,
Maksim
Since you only need to the lowest pay user appear on grand total level, we can achieve it via calculated measure. Sorry for the mistake in my previous post. Please refer to formula below:
Lowest Pay User = CALCULATE(VALUES(Table9[Name]),FILTER(Table9,Table9[Total Pay]=MIN(Table9[Total Pay])))
Regards,
You could use firstnonblank to find the lowest paid person, and then use that to extract their name in a measure.
Read my blog from last week here http://exceleratorbi.com.au/lastnonblank-explained/
you will need something like this
Lowest paid :=
CALCULATE (
If(hasonevalue(data[name]),Values(Data[name])),
FIRSTNONBLANK ( data[Salary], 1 ) )
)
It depends on your data model of course
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |