Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
AadiSingh_2018
Regular Visitor

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	100
04-04-2018	1	BB	Joe	200
24-09-2018	2	AA	Joe	300
24-09-2018	2	CC	Mark	400
25-09-2018	3	AA	Mark	500
25-09-2018	3	BB	Mark	600

 
When I prepare the dashboard using slicer (ID name) it doesn't show the ID (CC) and it also filtered from slicer (ID) along with Doc no.. Any idea to exclude the ID (CC) from slicer (ID name)
 
Date	Doc No_	        ID	Total
04-04-2018	1	AA	100
04-04-2018	1	BB	200
24-09-2018	2	AA	300
Grand Total	 	 	600

Is it any way to get the below result? Please help me it is urgent. I m trying from last three days and don’t succeed.

Date	Doc No_	ID	Total
43194	1	AA	100
43194	1	BB	200
43367	2	AA	300
43367	2	CC	400
Grand Total	 	1000
12 REPLIES 12
affan
Solution Sage
Solution Sage

Hi @AadiSingh_2018,

 

Can you please are your pbix power bi file so that I can help you on this problem

 

Regards

Affan

 

dear Affan,

 

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

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

entries.png

@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. 

 

 

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

Try this @AadiSingh_2018

 

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

Dear Baskar,

No it is not working, I used your formula but the result is same.

Date	Doc No	ID	Total
43194	1	AA	300
43194	1	BB	300
43367	2	AA	700

it is not showing the ID (CC) in ID column

Still Awaiting for help!!!

Baskar
Resident Rockstar
Resident Rockstar

@AadiSingh_2018 

Your requirement is not clear, what is ID Name slicer here. 

Can you please attach sample images from your PBI file. 

ID name is Name mentioned in Table

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.