Forum Discussion
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( {...
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])