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.
Community ChampionNot sure I fully understand that. If the difference between the two measures equals 0 then "green" otherwise "red".
Helper IIIHello 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
- tamerj1
Hi maibacherstr
You can create a difference measure to be used in the conditional formating as followsTable A Operational = CALCULATE ( COUNTROWS ( 'TABLE A' ), 'TABLE A'[Status] = "Operational" )Table B Operational = CALCULATE ( COUNTROWS ( 'TABLE B' ), 'TABLE B'[Status] = "Operational" )Difference = [Table A Operational] - [Table B Operational]- maibacherstr
tamerj1 thanks very much for posting so much detail. There is one last detail that I posted incorrectly, which is that TableB actually contains TotalOperationalQuantity in the rows, such as: Cars .... 12 Operational ; Trucks .... 9 Operational. Table A was described correctly, where 1 row = 1 record which why you wisely suggested using a countrows function. But Table B actually contains a sum in each row:
Table B:
Therefore Measure B still needs some work before the 3rd measure -- the subtraction equation -- will enable conditional formats to behave properly. Currently, my conditional formats are set up exactly as yours are.
Many thanks again
- maibacherstr
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:
MeasureB = SUM(TableB[TotalOperationalQuantity])