MEASURE TO COUNT VARIOUS VALUES FILTERED

[icosta7]

Hi there!
I am still crawling in PBI and it may be that my question is very basic,

but as I spent the whole afternoon looking for an answer on the forums and I didn't find anything, I decided to post my question here.

The thing is, I have a connection to the SQL Server of the Integrated System of the company I work for (hospital).

I am developing a CANCELLATION RATE indicator (KPI).

The calculation is as follows:
I need to know
the total number of TREATMENTS PERFORMED
+
the total of CANCELED TREATMENTS

A percentage of CANCELED TREATMENTS is the value of my indicator.

The goal is for it to stay below 3%.

Now for the calculations. In the table that I have my database.

* Leave a link with a sample file.

Exemple 

I need to COUNT and SUM THE SYSTEM STATUS are equal to " C", "FC", "SC"
The result is the total of TREATMENTS PERFORMED

I need to COUNT and SUM THE SYSTEM STATUS are equal to "X", "M", "E"
The result is the total of CANCELED TREATMENTS

SYSTEM STATUS = Status do Sistema

Prontuário = ID Number

Thanks in advance!

[MFelix · Accepted solution]

Hi @icosta7 ,

You need to create the following measures:

Tratamentos realizados = CALCULATE(COUNTA(data[Status do Sistema]);data[Status do Sistema] in {" C"; "FC"; "SC"})

Tratamentos cancelados = CALCULATE(COUNTA(data[Status do Sistema]);data[Status do Sistema] in {"E"; "M"; "X"})

Be aware that in some status you have a space before the code (example C) so I had to do it in the formula as you can see.

See attach file.

[icosta7]

Valeu amigo! Só fiz alguns pequenos ajustes e acrescentei uma nova medida. Ajudou bastante!