Forum Discussion
NEED HELP WITH DAX
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
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"
)
)
2 Replies
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"
)
)Thank you sooo much. I followed your dax and finally solved the issue. 🙏
