cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## showing max value and label on card

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 ?

2 REPLIES 2
Super User

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

Proud to be a Super User!

Super User

Hello @szrirem ,

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

 Vote for my Community Mobile App Idea

Proud to be a Super User!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors