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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Thanks for your help.

But in this case all the 3 measure are based on same filed .

Dax are - 

1.) Store = CALCULATE(DISTINCTCOUNT(Table[Incident ID]),FILTER(Table,Table[Store]=SELECTEDVALUE(Table[Store])))
 
2.)Division= CALCULATE(DISTINCTCOUNT(Table[Incident ID]),FILTER(Table,Table[Division]=SELECTEDVALUE(Table[Division])))

 

3.) Overall ---- I need to Calculate D.Count of Incident id without any filter.

 

This 3 i need to mention in same table.

 

If i filter Store and Division , Store and Division measure only need to change and Overall measure always needs to be same.

 

Please help here.

 

Thank you.

 

selimovd 

  • 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?