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, %])
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, %])
Robin_Lindstrom , you are welcome