Formula in Report Builder to Power BI

[Tiberwood]

Hello everybody, I need your help, I have this formula in Report Builder

=Sum(Fields!Sobremesa.Value, "Resumen_Ejecutivo_Tipo_Equipo2") / Sum(Fields!Total.Value, "Resumen_Equipos_etiquetas_de_fila")

this formula returns me a percentage value, I try replicate it in Power Bi without result...

Please please help me!!

[v-sihou-msft · Accepted solution]

@Tiberwood

You can use ALLEXCEPT()/ALL() to achieve same goal as "scope" in SSRS function. 

If you specify a dataset as scope, your measure can be like:

=
CALCULATE (
    SUM ( Resumen_Ejecutivo_Tipo_Equipo2[Sobremesa] ),
    ALL ( Resumen_Ejecutivo_Tipo_Equipo2 )
)
    / CALCULATE (
        SUM ( Resumen_Equipos_etiquetas_de_fila[Total] ),
        ALL ( Resumen_Equipos_etiquetas_de_fila )
    )

If you specify group as scope, your measure can be like:

=
CALCULATE (
    SUM ( Table[Sobremesa] ),
    ALLEXCEPT ( Table, Resumen_Ejecutivo_Tipo_Equipo2 )
)
    / CALCULATE (
        SUM ( Table[Total] ),
        ALLEXCEPT ( Table, Resumen_Equipos_etiquetas_de_fila )
    )

Regards,