Hi Team,
I am having truble to show the data in below formate. Please give us different idea or DAX formula, if i select ID in slicer, it just show the company name and respective ID form company name. Example and explination as below.
Table as below, each ID has unique Company name. but each Company Name has many ID.
ID Company Name
11 AA
12 AA
13 BB
14 AA
15 CC
16 BB
17 BB
18 CC
If have sclicer to slect the ID it show the Company name and also list of ID belongs to Comapny Name.
Examaple 1 :
if i select ID in sclicer as - 11 it should show comapnt name - AA and table it shows list of IDbelongs to Comapny Name like 11, 12, 14.
Slicer ID - 11
Company Name : AA
Table
ID
11
12
14
In slicer if i select ID, it will show the Company name. Then i tried using as button in company name, if i select the button(company name) it is showing respective ID in below table. it woks tottaly fine. But Every time if i want to select new ID in slicer, i have to uncheck the selected Comapny name. I want different idea or DAX formula to just show the company name and respective ID for company name. Please let me know if you need more information.
Thank you,
Abhilash
