Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help migrating form from Tableau to PowerBi

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!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you so much! It worked great!