Forum Discussion

NAV_81's avatar
NAV_81
Frequent Visitor
5 years ago

DAX - Count with Multiple Filters, Causing Memory Issues.

I am pretty new to DAX and am trying to do a count on some invoicing costs issues, there are some filters that need to apply to show what a true cost issue is. I have got the below to work the way I ...
Need Help
Mohammad_Refaei's avatar
Mohammad_Refaei
Solution Specialist
5 years ago

Can you try this?

Cost Issue Count =
CALCULATE (
    COUNTROWS ( Invoices ),
    FILTER (
        Invoices,
        [Cost Issue] < 0
            && [Est GP %] < 0.20
            && [CurrentSellInc] > 0
            && [CurrentSellLocationCode] <> "CLR"
            && [Invoice Status] <> "Killed"
    ),
    FILTER (
        'POS Item Details',
        [ModuleItem] = "F"
            && [PillarName] <> "Prescriptions"
    )
)