Forum Discussion

asofiacgraca's avatar
asofiacgraca
Icon for Helper I rankHelper I
3 years ago
Solved

How to iteratively group results in PowerBI

Hey 🙂 I am having some troubles writting a DAX querie for my purpose. I have a table with the following columns: IDofPurchase, Supplier, Fraccionated. In the fraccionated column i wrote the code i...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi asofiacgraca ,

    According to your description, here's my solution. Create a measure.

    Column =
VAR _Rank =
    RANKX (
        FILTER ( 'Table', 'Table'[Fraccionated] = "Close" ),
        'Table'[Supplier],
        ,
        ASC,
        DENSE
    )
RETURN
    IF ( [Fraccionated] = "Okay", "Okay", "Group" & _Rank )

    Get the correct result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi asofiacgraca ,

According to your description, here's my solution. Create a measure.

Column =
VAR _Rank =
    RANKX (
        FILTER ( 'Table', 'Table'[Fraccionated] = "Close" ),
        'Table'[Supplier],
        ,
        ASC,
        DENSE
    )
RETURN
    IF ( [Fraccionated] = "Okay", "Okay", "Group" & _Rank )

Get the correct result:

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • asofiacgraca's avatar
    asofiacgraca
    Icon for Helper I rankHelper I
    3 years ago

    Hey, that's perfect!

     

    Thanks 🙂