Convert tableau formula into power bi dax

[121Balu]

Hi team,

Please assist me for below formula which is in tableaue and kindly help me out to convert into power bi dax function.

Total Emp Count-Role Type Wise =
{ FIXED [Role  Type] : SUM(
{ FIXED [Branch Code],[Role  Type] : MAX([RoleWiseEmpCnt])
}
)}

[121Balu]

@amitchandak 

Thanks for your reply, however still my issue is not resolved. Still i am getting an error message.

Below is dax for your reference

Measure =

Var currnumber =

VALUES(Query2[Role])

Var summary =

SUMMARIZE(ALLSELECTED(Query2,Query2[Role],'Funnel resources'[Branch_Code]),"max_dp",MAX('Funnel resources'[RoleWiseEmpCnt]))

return

SUMX(FILTER(summary,Query2[Role] in currnumber),[max_dp])

[amitchandak]

@121Balu , refer to my video on the same topic

Tableau Vs Power BI-LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY