topic Re: RANKX & CARD in DAX Commands and Tips

RANKX & CARD

Anonymous — Wed, 02 Aug 2023 21:09:25 GMT

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.

Re: RANKX & CARD

johnt75 — Thu, 03 Aug 2023 09:43:43 GMT

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

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

Re: RANKX & CARD

Anonymous — Thu, 03 Aug 2023 10:56:05 GMT

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.

Re: RANKX & CARD

Anonymous — Thu, 03 Aug 2023 17:01:00 GMT

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

Re: RANKX & CARD

ERD — Thu, 03 Aug 2023 18:43:34 GMT

Anonymous , you only need this part:

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

Re: RANKX & CARD

Anonymous — Fri, 04 Aug 2023 17:40:38 GMT

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.

topic Re: RANKX &amp; CARD in DAX Commands and Tips

RANKX & CARD

Re: RANKX & CARD

Re: RANKX & CARD

Re: RANKX & CARD

Re: RANKX & CARD

Re: RANKX & CARD

topic Re: RANKX & CARD in DAX Commands and Tips