Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 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.
Anonymous's avatar
Anonymous
Not applicable
3 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
    3 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