Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove filter for Specific Measure or field

Hi,   I have a Visual like below, Whenever the Select Store and Division will filter out -Table column Store and Division only need to filter and Overall need not to be filter. Overall Fields need...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on my test, you need to create a new table for slicer like this:

    ForSlicer = DISTINCT(SELECTCOLUMNS('Table',"Select Store",[Store],"Division",[Division]))

    Then create a flag measure (when values matched , set as 1):

    Flag = IF(MAX('Table'[Store]) in ALLSELECTED('ForSlicer'[Select Store]) && MAX('Table'[Division])in ALLSELECTED('ForSlicer'[Division]) ,1)

    Now could find the matched row according to the flag measure:

    Store Measure = CALCULATE(MAX('Table'[Store]),FILTER('Table',[Flag]=1))
    Division Measure = CALCULATE(MAX('Table'[Division]),FILTER('Table',[Flag]=1))

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

I gave you a proposal for measure 3 [Overall].

Did you try that? Did it work?

 

Best regards

Denis

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ,

 

You gave me this,

My Overall Measure =
CALCULATE(
    SUM( myTable[Overall] ),
    ALL( StoreTable[Store] ),
    ALL( DivisionTable[Division] )
)

 But there is no Column like Store and Division.Not able to create Cal.Column also.

 

 

All the 3(Store,division and Overall) based on calculation of single column (#Incident id column)

 

So i tried below , but doesnt work.

Overall = CALCULATE(DISTINCTCOUNT(Table[Incident ID]),ALL(Table[Incident ID]))

 

Thanks,

Mohanraj

 

selimovd 

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Anonymous Then what are your slicers? They are not based on columns?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      Slicers are based on column.

       

      For Overall as you mentioned i put 

      Overall = CALCULATE(DISTINCTCOUNT(Table[Incident ID]),ALL(Table[Store]),ALL(Table[Division]))
       
      But,the result are like below,
       
      But i need like below, 

       

      My Requirement is Overall column need not to be filter out based on slicer, Also all the row item need to show.
       
      Thanks,
      Mohanraj
       
      • selimovd's avatar
        selimovd
        Most Valuable Professional
        5 years ago

        Hey Anonymous ,

         

        what is the "Status" we see in the table? This should not disappear.

        Can you share the file with me? It seems easier to take a look directly in your data.

         

        Best regards

        Denis