Solved: Re: Want to create a measure which count the speci...

MD12 · ‎02-09-2023

Want to create a mesure which counts the triagelevel 4 and 5 only.

TotunG · ‎02-09-2023

Hey, I guess by COUNT you mean just COUNT the occurrence. Try this measure and mark as a solution if it works:

Replace 'Table' with your Table name and [Number] with [TriageLevel]

COUNTIF = CALCULATE(COUNT('Table'[Number]),'Table'[Number]=4 || 5)

TotunG · ‎02-09-2023

Hey, I guess by COUNT you mean just COUNT the occurrence. Try this measure and mark as a solution if it works:

Replace 'Table' with your Table name and [Number] with [TriageLevel]

COUNTIF = CALCULATE(COUNT('Table'[Number]),'Table'[Number]=4 || 5)

MD12 · ‎02-09-2023

Triage level is a text column not a whole number.

TotunG · ‎02-09-2023

Still should work?

Want to create a measure which count the specific values from a column.