Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago
Solved

Calculated Column Count same table multiple filters

Hi experts! I have a table that shows me the status per sales order for specific regions: Sales Order Region Status 100 ADB Z 101 ADB Z 100 ADB X 101 ADB X 102 PRI O ...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi joshua1990 
    Please use the following

     

    Flag = 
NOT ISEMPTY (
    CALCULATETABLE ( 
        Sales, 
        ALLEXCEPT ( Sales, Sales[Sales Order], Sales[Region] ),
        Sales[Status] = "X" 
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi joshua1990 
Please use the following

 

Flag = 
NOT ISEMPTY (
    CALCULATETABLE ( 
        Sales, 
        ALLEXCEPT ( Sales, Sales[Sales Order], Sales[Region] ),
        Sales[Status] = "X" 
    )
)