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.
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