Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

RANKX & CARD

Hello,

 

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

 

DateEkipNameCollectionSourceGroupCollectionTRYCurrentUPB
01.06.2020InboundProtocol23423444354
10.10.2021OutboundDiger343244534
17.03.2022DigerExecution Office3423454
20.05.2022DigerSalary Attachment345454

 

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.

 

 

card
DAX
RANKX

5 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

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

    For Card =
CONCATENATEX (
    FILTER ( CollectionData, [SIRALAMA] = 1 ),
    CollectionData[EkipName],
    ","
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous , you only need this part:

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.