Forum Discussion
Get value from two data slicer which use the same column
- 1 year ago
Hi flo3o I think this is not possible to capture different value from 2 different slicer of the same column. To achieve this you need 2 disconnected table with single column.
If you want this, create 2 disconnect table using the same columne. For example:StartActivityTable = DISTINCT('YourTable'[Activity]) EndActivityTable = DISTINCT('YourTable'[Activity])Then create 2 different measure to capture Start and End activity. For example:
SelectedStartActivity = SELECTEDVALUE('StartActivityTable'[Activity]) SelectedEndActivity = SELECTEDVALUE('EndActivityTable'[Activity])Now you can use this 2 measure to your calculation to calculate the lead time between them.
Hope this helps!!If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi flo3o I think this is not possible to capture different value from 2 different slicer of the same column. To achieve this you need 2 disconnected table with single column.
If you want this, create 2 disconnect table using the same columne. For example:
StartActivityTable = DISTINCT('YourTable'[Activity])
EndActivityTable = DISTINCT('YourTable'[Activity])
Then create 2 different measure to capture Start and End activity. For example:
SelectedStartActivity = SELECTEDVALUE('StartActivityTable'[Activity])
SelectedEndActivity = SELECTEDVALUE('EndActivityTable'[Activity])
Now you can use this 2 measure to your calculation to calculate the lead time between them.
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz