Forum Discussion
AadiSingh_2018
7 years agoRegular 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
- BaskarResident Rockstar
Your requirement is not clear, what is ID Name slicer here.
Can you please attach sample images from your PBI file.
- AadiSingh_2018Regular Visitor
ID name is Name mentioned in Table
- affanSolution Sage
Hi AadiSingh_2018,
Can you please are your pbix power bi file so that I can help you on this problem
Regards
Affan
- AadiSingh_2018Regular Visitor
dear Affan,
I m new in this form and don't know how to add the file. I have excel file
- BaskarResident Rockstar