Dataset:- docs.google.com/spreadsheets/d/1D_I3mvh2ftvj2_oMHFbruGXPisoaeyCT/edit#gid=1511363485 DAX Code:- Net Revenue = Var vDepId= Max(Dept[DeptId]) Var VDepDetail=Max(Dept[Detail]) Var vTeamDetail= Max(Emp[TeamDetail]) Var vTeamScope=ISINSCOPE(Emp[TeamName]) Var vSubTeamScope=ISINSCOPE(Emp[SubTeam]) Var Rsum= CALCULATE( [Total Revenue], FILTER( ALL(Dept), Dept[DeptId]
Nice one Mishra Bhai 😊.
Thanku so much
Thank you
Dataset:- docs.google.com/spreadsheets/d/1D_I3mvh2ftvj2_oMHFbruGXPisoaeyCT/edit#gid=1511363485
DAX Code:-
Net Revenue =
Var vDepId= Max(Dept[DeptId])
Var VDepDetail=Max(Dept[Detail])
Var vTeamDetail= Max(Emp[TeamDetail])
Var vTeamScope=ISINSCOPE(Emp[TeamName])
Var vSubTeamScope=ISINSCOPE(Emp[SubTeam])
Var Rsum=
CALCULATE(
[Total Revenue],
FILTER(
ALL(Dept),
Dept[DeptId]