Forum Discussion

TerryStevens's avatar
TerryStevens
Regular Visitor
7 years ago

DAX statement to SUM filtered values

Hi. I am brand new to Power BI (4 hours in) and never worked with DAX before so I need a little help to get started.

 

For my first mini project I have a Stacked column chart that show 4 values which I have filtered from a possible 10 by using the checkboxes in the Visual Level filters section of the field controls (see below). The 4 bars have the individual values of 490, 482, 479 and 477. 

 

I now want to place a Card on the canvas that shows the SUM of the 4 bars (which is 1928).  I don't want the Card to show any individual bar values or include the values of the 'hidden' 6 values by the filter.

 

How do I do this?

 

Thanks in advance

 

Show and Tell

2 Replies

    • TerryStevens's avatar
      TerryStevens
      Regular Visitor
      7 years ago

      Thank you Tarun. I learnt something new from your reply (the Ask a Question feature) but unfortunatly this does not solve my query.

       

      I have now applied a Page Level filter to my categories to negate the need for a Slicer. I presume that whatever I add to the Page now will ignore the categories I have filtered out.

       

      So, I would like my Card to show the sum of the 4 bars shown in the bar chart which I know equates to 1928.

       

      Please help or advise if my understanding of the capability is incorrect.

       

      Thanks, Terry