Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count with Multiple Conditions and Multiple Column Referenced

Hello,   I'm currently stumped on a DAX formula, which I need to count the number of entries in a column (let's call it Rule). I need it to be filtered for the following conditions which are conta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg,

 

How can I use CALCULATETABLE to reference a column in a different table? I can only get CALCULATETABLE to reference Table1, but not Table 2.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I've now tried the following:

Count of Rule for Active = 
COUNTROWS (
    CALCULATETABLE ('Table1',
    FILTER('Table1',
        'Table1'[Status] = "Active"),
    FILTER('Table1',
        'Table1'[Condition] = "Perfoming As Expected"),
    FILTER('Table2',
        OR('Table2'[PercentageBin] = "81-90%",
            'Table2'[PercentageBin] = "91-100%")
        )
    )
)

 

Still showing (Blank) when I dragged this Measure into a Card.

I'm not if this affects it, but I also have other columns like [Region] and [Country] in Table 1, which I have Slicer created for. Do I need to adjust my DAX to include reference to [Country] and [Region]?