Forum Discussion

AadiSingh_2018's avatar
AadiSingh_2018
Regular Visitor
8 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    AadiSingh_2018 

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

    Can you please attach sample images from your PBI file. 

  • affan's avatar
    affan
    Icon for Solution Sage rankSolution Sage

    Hi AadiSingh_2018,

     

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

     

    Regards

    Affan