From Tableau to PowerBI DAX

Hi tanako123

Your Tableau formula is the equivalent of a calculated column that says:

1. For each row, examine all rows with [FormulierId] equal to the value in the current row
2. If any of those rows has [Type melding (group)] with substring 'Reguliere melding' then return 'Reguliere melding'
3. Else if any of those rows has [Type melding (group)] with substring 'Politiemelding' then return 'Politiemelding'
4. Else return Null

The DAX equivalent would have to be a calculated column with code like this (I'm calling the table Data):

Calculated Column =
IF (
    NOT (
        ISEMPTY (
            CALCULATETABLE (
                VALUES ( Data[Type melding (group)] ),
                ALLEXCEPT ( Data, Data[FormulierId] ),
                NOT ( ISERROR ( FIND ( "Reguliere melding", Data[Type melding (group)] ) ) )
            )
        )
    ),
    "Reguliere melding",
    IF (
        NOT (
            ISEMPTY (
                CALCULATETABLE (
                    VALUES ( Data[Type melding (group)] ),
                    ALLEXCEPT ( Data, Data[FormulierId] ),
                    NOT ( ISERROR ( FIND ( "Politiemelding", Data[Type melding (group)] ) ) )
                )
            )
        ),
        "Politiemelding"
    )
)

By the way, the Tableau formula is written a little strangely, since

{ FIXED [FormulierId]:MAX('Reguliere melding')}

could be replaced with

'Reguliere melding'

 but this could be because it started off as something more complex.

Regards,

Owen