Forum Discussion

121Balu's avatar
121Balu
Frequent Visitor
3 years ago

Convert tableau formula into power bi dax

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])
}
)}

Need Help

2 Replies

  • 121Balu's avatar
    121Balu
    Frequent Visitor
    3 years ago

    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])