showing max value and label on card

[szrirem]

Hello everyone,

I am trying to show max value and max value label on card. I did a visualization like below. 

I want to print the maximum number of 541 in this visualization and its label on card. I wrote a formula like below to get 541. But the label is wrong.

Measure =

 MAXX(

    KEEPFILTERS(VALUES('Yol Izin Belge Sayisi'[Belgeyi Veren Birim])),

    CALCULATE([Toplam Yol İzin Belgesi Alan Kişi Sayısı])

)

with these code I calculated 542 but I couldnt display true label. The label has to be Mersin 

How can I do this ?

Thank you in advance 

[Arul]

@szrirem ,

modify and try this measure based on you data,

Max sales by segment = 
VAR _maxX = MAXX(
    VALUES(financials[Segment]),
    CALCULATE([Sum of Sales]))
VAR _tempTable = 
SUMMARIZE(
    financials,
    financials[Segment],"@Sales",SUM(financials[ Sales])
)
VAR _result =  CALCULATE(
    SELECTEDVALUE(financials[Segment]),FILTER(_tempTable,[@Sales] = _maxX))
RETURN _result

Thanks,

Arul

[Idrissshatila]

Hello @szrirem ,

Try adding the measure you made along with the dimension you're using in a multi-row card.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin