Forum Discussion
Compare Count of String Between Two Tables Given a Status Column
- 3 years ago
Hi maibacherstr
Apologies for the late reply. Please refer to attached sample file.
I thought the measure should be super easy, but the Difference equation is not producing the desired formatting behavior... Here's what I'm trying to use:
Hi maibacherstr
can you please share a relevant sample of data and advise the expected results based on it?
- maibacherstr4 years ago
Helper III
Hello Anonymous, I just learned that .xlsx files can't be uploaded here --? After doing my best to recreate a useful dataset example. Unfortunately the full dataset is not mine to share, but I hope the following can still come in helpful. I suspect my MeasureB is the problem.
Many thanks again, I hope this screenshot is still useful.
- tamerj14 years ago
Community Champion
Hi maibacherstr
you can upload to WeTransfer, OneDrive, dropbox or any other service and share the download link.
- maibacherstr3 years ago
Helper III
Hi tamerj1 this obviously took a little time to get situated. But the link to a sample report should be available to you via OneDrive below. I recreated the report very carefully in a sample set.
I'm certain that Measure B needs some work. I have a strong feeling that with your expertise this could be solved very quickly. Here's a quick preview, and the link at the bottom.
Eager to award kudos; as before, I *greatly* appreciate your time, energy and expertise.
- tamerj13 years ago
Community Champion
Hi 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? - maibacherstr3 years ago
Helper III
Measure 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