Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 product and for each product percentage is calculated. Now I need another calculation as if you take Product Beverage, then New Calculation= %M of Beverage/(%M of Beverage + % M of Dairy + %M of Chem+%M of Food+ %M of Pharma). Unknown is not considered. Same repeated for each Product except Unknown.
Is there any possible way to write a DAX Expression. Please help me with it.
Thanks,
James
Solved! Go to Solution.
Hi @Anonymous
Measure = [%M]/SUMX(FILTER(ALL(Sheet3),[Product]<>"Unknown"),[%M])
Best Regards
Maggie
Hi @Anonymous
Measure = [%M]/SUMX(FILTER(ALL(Sheet3),[Product]<>"Unknown"),[%M])
Best Regards
Maggie
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |