Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Ignore specific filters applied in table total values

Team, I have a table with 6 categories as below

 

CategoryOrderMonth Price  MRP 
AJan                           879                  1,029
BJan                        5,645                  5,795
CJan                           564                      714
DJan                        8,975                  9,125
EJan                        5,643                  5,793
FJan                           321                      471
AFeb                           213                      363
BFeb                        5,464                  5,614
CFeb                           654                      804
DFeb                           854                  1,004
EFeb                              63                      213
FFeb                           564                      714
Total                      29,839                31,639

 

In the Filters pane, I have applied OrderMonth = Jan and Category <> F. But, in my output table I need the Total should Ignore the Category Filter which I had applied as Category <> F and should SUM the Price, MRP for all categories in Jan (including category F). But, category F should not be seen in the output table as mentioned below.

 

Note: Price, MRP are measures.

CategoryOrderMonth Price  MRP 
AJan                           879                  1,029
BJan                        5,645                  5,795
CJan                           564                      714
DJan                        8,975                  9,125
EJan                        5,643                  5,793
Total                      22,02722,927

 

Any help is much appreciated.

Thanks,

Need Help
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can use the below Measure to filter your visual table.

    Measure = 
INT( 
    NOT( 
        SELECTEDVALUE( 'Table'[Category] ) = "F" 
    ) 
)

     Please see the below for reference.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

3 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

     

    You can use the below Measure to filter your visual table.

    Measure = 
INT( 
    NOT( 
        SELECTEDVALUE( 'Table'[Category] ) = "F" 
    ) 
)

     Please see the below for reference.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Mariusz ! That helps 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous,

    I'd like to suggest you add if statement to your measure formula to check the row content level. If current is 'total' level, you can write a formula to add filter records calculation result with enabled filter effect.

    Clever Hierarchy Handling in DAX 

    Regards,

    Xiaoxin Sheng