Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ignore Filters from multiple tables in DAX

Hi, I have a scenario to calculate "Current Month's Orders" whose values should be constant and not change when any filter/slicer from multiple tables is applied. I have four slicers from four diffe...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

     

    CALCULATE(DISTINCTCOUNT('olap fact_Transaction'[order_id]),
    FILTER(ALL('olap dim_Date'),[Current_YearMonth]="TRUE"),ALL('olap dim_TransactionType'),ALL('olap dim_Client'))

     

    CALCULATE(DISTINCTCOUNT('olap fact_Transaction'[order_id]),
    FILTER(ALL('olap dim_Date'),[Current_YearMonth]="TRUE"),ALL('olap dim_TransactionType'),ALL('olap fact_Transaction'),ALL('olap dim_Client'))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

 

CALCULATE(DISTINCTCOUNT('olap fact_Transaction'[order_id]),
FILTER(ALL('olap dim_Date'),[Current_YearMonth]="TRUE"),ALL('olap dim_TransactionType'),ALL('olap dim_Client'))

 

CALCULATE(DISTINCTCOUNT('olap fact_Transaction'[order_id]),
FILTER(ALL('olap dim_Date'),[Current_YearMonth]="TRUE"),ALL('olap dim_TransactionType'),ALL('olap fact_Transaction'),ALL('olap dim_Client'))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak,

This works, thanks a lot ðŸ˜Š .