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