How to divide certains values from a column with the total of the column

[ionutbolos]

Hello Everyone

I am trying to divide certain values from a column with the total column.

Below is a sample:

Rating Experience

Negative

Negative

Negative

Positive

Neutral

Positive

Neutral

Positive

Negative

I this case I am trying to divide the negatives with the total number of the column.

[v-frfei-msft]

Hi @ionutbolos ,

Here we can format the measure to percentage instead of changing it in visual. As in visual, you might get the percentage of some other category.

[Anonymous]

I think this should work

Measure=
VAR __Count= COUNTROWS( TABLE )

VAR __NegCount =
    CALCULATE(
        __Count,
        TABLE[RATNG EXPERIENCE]= "Negative"
    )

RETURN

DIVIDE (__NegCount,__Count)

[Ronald123 · Accepted solution]

@ionutbolos ,

Try this;

Sample = DIVIDE(
    CALCULATE(
    COUNT('Table'[Rating Experience]);
    'Table'[Rating Experience]="Negative");
    COUNTROWS('Table'))

Greetz,

Ronald

[ionutbolos]

Thanks! That worked. It shows the correct value (eg. below 0.14) but when it transforms it into percentage in the pie chart it shows a different value. Do you happen to know why it showing like this?