Forum Discussion
maibacherstr
Helper III
Helper IIICompare Count of String Between Two Tables Given a Status Column
Hello, I'm stuck on the following measure. I have two tables, each with a Status column, and need to compare the number of "Operational" rows for each value in the Type column (in this example Type =...
Hi maibacherstr
Apologies for the late reply. Please refer to attached sample file.
tamerj1
Community Champion
Community ChampionHi maibacherstr
am using my phone right now so I cannot see the pbix file. What is the dax for measure B?
count snd total are measures or aggregated columns? Measures what is the dax if aggregated columns then what type of aggregation?
maibacherstrHelper III
Helper IIIMeasure B is still the same as I had it originally:
= SUM(TableB[TotalOperationalQuantity])
But the sum should only apply to the status value, "Operational". I'm not sure I follow your other questions.
Thank you