Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Replicate Tableau FIXED function to Power BI

Necesito replicar esta función de Tableau en Power BI:
{FIXED [Broker] : SUM([PG BRT])}

I already tried several functions such as ALLEXEPT, SUMMARIZE, SUMX but I could not replicate the result.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Syndicate_Admin ,

    Please have a try.

    Create a measure.

    Fixed Sum = SUMX(VALUES(Sales[Broker]), CALCULATE(SUM(Sales[PG BRT])))

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

    • RomanG123's avatar
      RomanG123
      Helper II
      2 years ago

      Compartire unas screenshots de Tableau para entender como deberia funcionar la medida...

      Medida PG Corretor en Tableau dividido por otras columnas:

      Si le agregamos la columna Corretor arrojaria los siguientes resultados: 

       

       

      La medida que me proporcionaste me dió el siguiente resultado:

       

       

       

       

      Muchas gracias por la ayuda igualmente, si se les ocurre otra solución se lo agradeceria