Calculate and filter out value in a column

[Anonymous]

I have a column with 3 different values, say low, normal and high, and I wanna make a KPI of each low, high and normal how many of them there are. I have use this below but get error.

measure = CALCULATE(COUNTA([column1]); FILTER(HIGH);))

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample and your desired output so that we could get your question quickly answered.

Best  Regards,

Cherry

[Anonymous]

Hi buddy,

try use this:

Measure: CALCULATE(COUNTA([column1]); FILTER(Table;[column KPI]="High"))

Normally the filter formula ask you to say exactly what you want.

Any questions, ask 😉