Forum Discussion
Solved
Help with DAX formula
Hello everyone, I need some help regarding DAX. So in my example, I have 5 Arenas ( i.e., products) where I am trying to create a DAX-formula showing total "OO GM%" (Gross Margin%). In order ...
As variant
Weighted %%:=VAR allBrutto=CALCULATE( [Brutto_M], ALLEXCEPT(Arena,Arena[ArenaCode]) ) RETURN DIVIDE([Brutto_M], allBrutto) OO GM, %%:=IF ( ISFILTERED( Arena[Arena]), [Weighted %%]*[Revshare_M], [OO GM, %])
You may use measure like
OO GM, %:=IF (
ISFILTERED( Arena[Arena]),
[OO GM%],
SUMX (
GROUPBY(Arena,Arena[Arena],Arena[ArenaCode]),
[OO GM%])
)