Forum Discussion

Fusilier's avatar
Fusilier
Helper III
1 year ago
Solved

Help 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...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    1 year ago

    I tried with a sample data and simple calculation. It's getting as expected

     

  • Anonymous's avatar
    Anonymous
    1 year 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 He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Kaviraj11's avatar
Kaviraj11
Solution Sage
1 year ago

Hi,

 

Can you try with the measure below:

 

%fromAll SBCLGA =
DIVIDE(
SUM('Raw Data'[row count]),
SUMX(
ALL('Raw Data'[Answers aggregated]),
'Raw Data'[row count]
)
)

  • Fusilier's avatar
    Fusilier
    Helper III
    1 year ago

    Thanks for your help but it doesn't work. The measure won't accept 'row count' in the 

    SUMX(
    ALL('Raw Data'[Answers aggregated]),
    'Raw Data'[row count]
    )

     

    Part of the measure.

    'row count' is a calculated field here, so maybe that is the problem.

    I've tried replacing that bit with a countrows measure, which works, but its still returning 14.68% instead of 11.15%.

    Its still completely ignoring the Question D row total (69), I think because the Disagree response is nil.

    My original measure works fine apart for rows with a null response 

    Scratching my head over this.