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

dear Affan,

 

I m new in this form and don't know how to add the file. I have excel file

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