RANKX & CARD

[Oguzhan0556]

Hello,

I have a dataset named "CollectionData". I will introduce you the columns in the table and the first 5 rows in these columns.

Date	EkipName	CollectionSourceGroup	CollectionTRY	CurrentUPB
01.06.2020	Inbound	Protocol	234234	44354
10.10.2021	Outbound	Diger	34324	4534
17.03.2022	Diger	Execution Office	342	3454
20.05.2022	Diger	Salary Attachment	345	454

Toplam Tahsilat = SUM(CollectionData[CollectionTRY])

Toplam Anapara = SUM(CollectionData[CurrentUPB])

What I want to do is I split the "Toplam Tahsilat" and "Toplam Anapara" fields into each other. I sorted them by "EkipName" and "CollectionSourceName" columns, from largest to smallest. No problems so far. I am sharing the Measure below.

SIRALAMA =

IF(
OR(
HASONEFILTER(CollectionData[EkipName]),
HASONEFILTER(CollectionData[CollectionSourceGroup])
),
RANKX(
ALL(CollectionData[EkipName],CollectionData[CollectionSourceGroup]),
DIVIDE([Toplam Tahsilat], [Toplam Anapara], 0)
)
)

It should not be forgotten that there was also a "Date" field in Raw Data, but I removed the "Date" field in the table. So I changed the Context and sorted accordingly.

But what I want to do is I want to show the value of "EkipName" as "Card" of the row with the largest order. I wrote the following DAX for this, but it doesn't work. Because the Context is different.

ForCard =

IF (

    [SIRALAMA] = 1,

    MAXX ( FILTER ( CollectionData , [SIRALAMA] = 1 ), CollectionData[EkipName] )

)

Can anyone help? Thanks.

[ERD]

@Oguzhan0556 , you only need this part:

ForCard = 
MAXX ( FILTER ( CollectionData , [SIRALAMA] = 1 ), CollectionData[EkipName] )

[Oguzhan0556]

Unfortunately it does not give the correct value. Can you share your e-mail address if it is suitable for you? Shall I send the PBI file? If you can send it here, I can send it here too.

[Oguzhan0556]

Hello,

Thanks for the answer. I seem to remember that I tried this code, but I wasn't sure. I'll check it tonight and post my answer. Thanks again.

[johnt75]

You need to remove the IF statement as that will never be true

For Card =
CONCATENATEX (
    FILTER ( CollectionData, [SIRALAMA] = 1 ),
    CollectionData[EkipName],
    ","
)

[Oguzhan0556]

I tried it and got the following result 🙂 The value that should appear on the card should be "Outbound".