Replicate Tableau FIXED function to Power BI

[Syndicate_Admin]

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]

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]

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

[Syndicate_Admin]

.