Forum Discussion
Fusilier
Helper III
2 years agoHelp with % measure
Hi, I have a problem with this measure: %fromAll SBCLGA = DIVIDE( SUM('Raw Data'[row count]), CALCULATE(SUM('Raw Data'[row count]), all('Raw Data'[Answers aggregated]))) The table below i...
- 2 years ago
I tried with a sample data and simple calculation. It's getting as expected
- Anonymous2 years ago
Hi Fusilier ,
As Kaviraj11 said. You just need to create a simple dax expressions.Disagree percentage = DIVIDE( SUM('Table'[Disagree]), CALCULATE( SUM('Table'[Agree])+SUM('Table'[Disagree])+SUM('Table'[Neutral]), ALL('Table') ) )This will return the percentage of each row of data in the total data and provide the sum
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Kaviraj11
Solution Sage
2 years ago
I tried with a sample data and simple calculation. It's getting as expected