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'))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

    Did you mean like this?

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

    But I don't think it's the right syntax. Can you tell me the correct syntax?