Forum Discussion

maibacherstr's avatar
maibacherstr
Icon for Helper III rankHelper III
4 years ago
Solved

Compare 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 =...
Need Help DAX
Need Help DAX measure
maibacherstr's avatar
maibacherstr
Icon for Helper III rankHelper III
4 years ago

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi maibacherstr 
You can create a difference measure to be used in the conditional formating as follows

Table 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]