Forum Discussion

Robin_Lindstrom's avatar
Robin_Lindstrom
Copper Contributor
Apr 14, 2021
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 ...
BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 14, 2021

    Robin_Lindstrom 

    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, %])

     

Resources