topic NEED HELP WITH DAX in DAX Commands and Tips

NEED HELP WITH DAX

LeonardCs — Wed, 24 Jul 2024 14:49:27 GMT

Hi everyone,

I have a table with some types of exams and I need to calculate total of them. The issue is that some exams are in column "Exames_Realizados" and some exams are in column "Exames_Adicionais". For exemple:

Name	Exames_Realizados	Exames_Adicionais
Leonardo	BIÓPSIA POR ESTEREOTAXIA	RNM
Rafael	BIÓPSIA POR USG	BIOPSIA DE LINFONODO
Will	BIÓPISIA TIPO1	BIÓPSIA POR USG
Sophie	MMG	AGUARDANDO
Taylor	PAAF LINFONODO	BIÓPSIA POR ESTEREOTAXIA
Pitty	PAAF TIREOIDE	SEGUIMENTO PELA ESF
Bryan	RNM	USG
Maria	USG	BIOPSIA DE LINFONODO
John	DOPPLER	USG

I need to know and show how much exams for types were carried out

Re: NEED HELP WITH DAX

sandrika — Wed, 24 Jul 2024 14:57:01 GMT

You can create a new table that combines the "Exames_Realizados" and "Exames_Adicionais" columns. Use the following DAX code:
ExamsTable =
UNION (
SELECTCOLUMNS (
YourTable,
"Name", YourTable[Name],
"Exam", YourTable[Exames_Realizados]
),
SELECTCOLUMNS (
YourTable,
"Name", YourTable[Name],
"Exam", YourTable[Exames_Adicionais]
)
)
Replace 'YourTable' with the name of your original table.

Next, you can create a measure to count the occurrences of each type of exam:
TotalExams =
COUNTROWS (
FILTER (
ExamsTable,
ExamsTable[Exam] <> "AGUARDANDO" && ExamsTable[Exam] <> "SEGUIMENTO PELA ESF"
)
)

Re: NEED HELP WITH DAX

LeonardCs — Wed, 24 Jul 2024 15:04:20 GMT

Thank you sooo much. I followed your dax and finally solved the issue. 🙏