Forum Discussion

Skumaran's avatar
Skumaran
Regular Visitor
4 years ago
Solved

How to remove the filter from a measure

Hi,

 

I am trying to analyse a data set, below is the sample data

 

is it possible to get the count of a particular item ( slicer) and the total count of all the items for the order #?

 

What I am trying is to do is to add "Item" as slicer and I need to get the Count of selected item and the Total count of all the items in an Order #

 

for example if I add "Wire" in the slider the table should display the Count of selected Item as "1" and I need a measure to display the total count as "5" for the Order # as below

 

How do I create a measure to exclude the filter and show the Total count of all the items of an Order #

 

Kindly help to resolve this,

 

Regards,

Shyam.

 

  • Try:

    Total count of items = CALCULATE (COUNT(Table[Item]), ALL(Table[Item]))

  • Hi Skumaran

     

    You didn't close your Count() function correctly.

    CALCULATE(COUNT(Sheet3[Item]),ALL(Sheet3[Item]))

     

    Hope it helps!

     

    Kind regards,

    OD

4 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion

    Try:

    Total count of items = CALCULATE (COUNT(Table[Item]), ALL(Table[Item]))

    • Skumaran's avatar
      Skumaran
      Regular Visitor

      Hi Paul, 

       

      Thank you for your response,

       

      I tried as you suggested but it returned with an error,

       

       

      • OzkanDhont's avatar
        OzkanDhont
        Icon for Resolver II rankResolver II

        Hi Skumaran

         

        You didn't close your Count() function correctly.

        CALCULATE(COUNT(Sheet3[Item]),ALL(Sheet3[Item]))

         

        Hope it helps!

         

        Kind regards,

        OD