I have implemented bellow logic in tableau. I need same to be implements in power bi please help me.

[Anonymous]

{ FIXED [BPO],DATEPART('month', [Month]),DATEPART('year', [Month]):
 SUM([Total Complaints Received Admin + Calls])}/{AVG([Inforce policies])}*100

[Anonymous]

HI @Anonymous,,

Fixed function seems summarize fields which you define after fix function, then use these as summary group to calculate with column defined after ':' character.

You can try to use following measure if it works:

Measure =
CALCULATE (
    SUM ( TABLE[Total Complaints Received Admin + Calls] ),
    ALLSELECTED ( TABLE ),
    VALUES ( TABLE[BPO] ),
    VALUES ( TABLE[Year] ),
    VALUES ( TABLE[Month] )
)
    / AVERAGE ( Table[Inforce policies] )
    * 100

Regards,

Xiaoxin Sheng

[AlexisOlson · Accepted solution]

It would help if you explained what the logic does. I'm sure I'm not the only one who doesn't remember clearly how FIXED works in Tableau.

[Anonymous]

Please check beloow link.

https://onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm