Measure to calculate a percentage of total based on multiple responses

Mike35 — Tue, 18 Jun 2024 13:05:49 GMT

Hi all,

Hoping someone can help. I'm looking to create a measure which demonstrates a Total % based on multiple count values of data in a given field. The measure would then be used in conjunction with a date slicer to have a total % not just per day, but for a selection of days. For example;

Table name: Observation

If "YES" or "MAYBE" are entered it would be calculated as a positive response which I'm looking to calculate as a % to display in a card visual.

On 01/06/2024, there are 2 "YES, 1 "MAYBE" and 1 "NO" response, calculating as 75%.

On 01/06/2024-03/06/2024 inclusive, there are 6 "YES", 3 "MAYBE", 9 "NO" responses, so the pecentage is 50%.

Thanks in advance for any solutions you can help with.

Re: Measure to calculate a percentage of total based on multiple responses

bhanu_gautam — Tue, 18 Jun 2024 13:14:53 GMT

Mike35 , Try using below formula

Total % = 
DIVIDE(
    CALCULATE(
        COUNTROWS('YourTable'),
        'YourTable'[Score] = "YES" || 'YourTable'[Score] = "MAYBE"
    ),
    CALCULATE(
        COUNTROWS('YourTable'),
        ALLEXCEPT('YourTable', 'YourTable'[Date])
    )
)

topic Re: Measure to calculate a percentage of total based on multiple responses in DAX Commands and Tips

Measure to calculate a percentage of total based on multiple responses

Re: Measure to calculate a percentage of total based on multiple responses