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, %])
Or you may modify the measure like this...
OO GM% :=
IF (
ISFILTERED ( Arena[Arena] ),
[Revshare_M] * [Weighted %],
SUMX (
Arena,
[Revshare_M] * [Weighted %]
)
)
This actually works, but when displaying more than one package the "weighted" should pay attention to the individual package and should always add upp to 100%, otherwise it seems to work.
Any ideas? 🙂
br,
R
- Can you mock up the desired output as you did in your first sample file and upload it again?
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, %])