Forum Discussion

AadiSingh_2018's avatar
AadiSingh_2018
Regular Visitor
7 years ago

Help needed urgently DAX

Hi Dax is new for Me. I just want to use slicer (ID name) to filter the Doc No. but the same time, I don't want to filter ID Name in Table. Date Doc No_ ID ID Name Amount 04-04-2018 1 AA Joe...
Need Help
AadiSingh_2018's avatar
AadiSingh_2018
Regular Visitor
7 years ago

Please advise how to do this but please note that i have millons of rows of Doc no. and also hundred of rows of ID name

  • Baskar's avatar
    Baskar
    Resident Rockstar
    7 years ago

    AadiSingh_2018

    whenever you apply the filter on ID Name it won't effect the table . This is you requirement correct ? 

    If Yes, follow the below steps

    1. Click the ID Name filter

    2. Go to the Format ribbon on top menu 

    3. Click the Edit Interaction button

    4. Click the None icon on the Table. So the matter here we stop the ID Name interaction the table. 

     

     

    • AadiSingh_2018's avatar
      AadiSingh_2018
      Regular Visitor
      7 years ago

      Dear Baskar

       

      Thanks for your vaulable Time, i m using dax for POwer pivot not for Power BI and second I want to apply  filter Doc No column  (Document Number) in table but exlcude the filter on ID column in same table. is there any way, using index coloum for adding new table or any??

      • Baskar's avatar
        Baskar
        Resident Rockstar
        7 years ago

        Try this AadiSingh_2018

         

        Total = CALCULATE(SUM(Slicer[Amount]),ALLEXCEPT(Slicer,Slicer[Doc No]))