Forum Discussion
DAX CALCULATION
I'm trying to GM % on a row based. Net GP/Sales. Please can someone help me.
amitchandak I'm trying to used SelectedValue & Switch function. This is how the actuals & Budget was Calculated.
Anonymous , what is the difference in the measure? for each switch value. I think, need to look into details, what was needed and why the above was needed
amitchandak What was needed is the GM % from Acutal & Budget Values. Divide 541,093.85/2,036,933.92 = Baked Good Gross Margin. Every line descriptioin has a Gross Margin attribute Users wants fill in those gross margin attribute.