Help migrating form from Tableau to PowerBi

[Anonymous]

Hello, sorry to bother you all guys, but I'm struggling with this and can't figure out how to solve it.

I have this formula of a calculated column from tableau:

I'm trying to replicate it and do the same en power bi, but I can't get it to work properly since I cant replicate in a column the use of MAX and FIXED, I tried this but I don't know if its correct and it's missing the MAX also:

Could somebody give me a hand?

Thank you very much!

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

You can use the MAXX function instead:

https://docs.microsoft.com/en-us/dax/maxx-function-dax

SEMAFORO EPICA =
VAR AUX =
    SWITCH (
        'JIRA_INGENIERIA_FEATURES'[JIRA_INGENIERIA_EPICAS.ESTADO],
        "Cerrado", 0.1,
        "Cancelado", 0.11,
        "En espera", 0.5,
        IF (
            'JIRA_INGENIERIA_FEATURES'[SEMAFORO FEATURE] = 2
                || 'JIRA_INGENIERIA_FEATURES'[SEMAFORO FEATURE] = 3,
            'JIRA_INGENIERIA_FEATURES'[SEMAFORO FEATURE],
            1
        )
    )
RETURN
    MAXX (
        FILTER (
            ALL ( JIRA_INGENIERIA_FEATURES ),
            'JIRA_INGENIERIA_FEATURES'[JIRA_INGENIERIA_EPICAS.ESTADO]
                = MAX ( 'JIRA_INGENIERIA_FEATURES'[JIRA_INGENIERIA_EPICAS.ESTADO] )
        ),
        AUX
    )

Best Regards,

Liu Yang

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

[Anonymous]

Thank you so much! It worked great!

[amitchandak]

@Anonymous for fixed LOD, You have use allexcept with fact /central tbale

example

, calculate([Net], allexcept (sales, Item[Brand], Geo[City]) )

Try

LOD- FIXED (Level of Details) - Revisited: https://youtu.be/hU-cVOwDCvY

[Anonymous]

Hello! Yes, I'm using it, but my question remains for the MAX, how can I include it and do as the formula in tableau? If I try to copy it to DAX i cant