Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help in writing DAX Measure

Hello All,               I have a table with columns Product, Amount Sales and Financial Month. I have created a measure to calculate percentage for each product. As seen in the table, I have...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Measure = [%M]/SUMX(FILTER(ALL(Sheet3),[Product]<>"Unknown"),[%M])

     

     

     

     

    Best Regards

    Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'd be expecting you want something like this:

New Calculation = var PctBeverage = CALCULATE(
	[%M],
	'YourTable'[Product] = "Beverage"
)
var PctDenominator = CALCULATE(
	[%M],
	NOT 'YourTable'[Product] = "Unknown"
)
RETURN
DIVIDE(
	PctBeverage,
	PctDenominator
)