Forum Discussion
Helper IIICompare Count of String Between Two Tables Given a Status Column
Hi maibacherstr
Apologies for the late reply. Please refer to attached sample file.
Helper IIIHi tamerj1 thanks for starting to think this over. There is no bridge table, but as mentioned the two tables are already related -- they use the Type columns as keys.
Since the tables come from two very different data sources, one being extremely limited for its columns, there is no ID column or other unique values available for building that relationship.
Thanks again
Community Championplease try
CALCULATE (
COUNTROWS ( TableA ),
TableA[Status] = "Operational"
)
Same for TableB
- maibacherstr
tamerj1 It seems like there are some gaps between this measure and being about to compare both counts, such that if there is a difference between the two, then the result of the measure enables a conditional format. What am I missing, please?
- tamerj1
Not sure I fully understand that. If the difference between the two measures equals 0 then "green" otherwise "red".
- maibacherstr
Hello tamerj1 I understand the fundamentals of the difference problem, but still the question of how specifically to implement it. How many measures will be used? If 1, will it require the =related() function to be used, or something like that? Thank you