Forum Discussion
multiple field parameters controlled by one slicer or another filed parameter
- Anonymous1 year ago
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi, dnzdvd
Regarding the issue you raised, my solution is as follows:
1.First I have created the following table and the column names and data are the data you have given:
2.Create the following calculated table to combine the contents of the two parameters into one table:
Table = VAR p1 = SELECTCOLUMNS ( 'Parameter1', "1", 'Parameter1'[Parameter], "2", 'Parameter1'[Value4] ) VAR p2 = SELECTCOLUMNS ( 'Parameter2', "1", 'Parameter2'[Parameter2], "2", 'Parameter2'[Value4] ) RETURN UNION ( p1, p2 )3.Secondly, create two measures, each applied to the respective slicers:
OOO1 = VAR CC1 = VALUES ( 'Table'[1] ) RETURN IF ( MAX ( 'Parameter1'[Parameter] ) IN CC1, 1, 0 )OOO2 = VAR CC2 = VALUES ( 'Table'[1] ) RETURN IF ( MAX ( 'Parameter2'[Parameter2] ) IN CC2, 1, 0 )4.Here are the final results:
5.Of course, you might also consider establishing a relationship between the two parameters:
However, the drawback is that if you create a slicer, it will only filter the contents of this table and those that belong to the same group as the selected content.
Please find the attached pbix relevant to the case.
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi, dnzdvd
Regarding the issue you raised, my solution is as follows:
1.First I have created the following table and the column names and data are the data you have given:
2.Create the following calculated table to combine the contents of the two parameters into one table:
Table =
VAR p1 =
SELECTCOLUMNS (
'Parameter1',
"1", 'Parameter1'[Parameter],
"2", 'Parameter1'[Value4]
)
VAR p2 =
SELECTCOLUMNS (
'Parameter2',
"1", 'Parameter2'[Parameter2],
"2", 'Parameter2'[Value4]
)
RETURN
UNION ( p1, p2 )
3.Secondly, create two measures, each applied to the respective slicers:
OOO1 =
VAR CC1 =
VALUES ( 'Table'[1] )
RETURN
IF ( MAX ( 'Parameter1'[Parameter] ) IN CC1, 1, 0 )
OOO2 =
VAR CC2 =
VALUES ( 'Table'[1] )
RETURN
IF ( MAX ( 'Parameter2'[Parameter2] ) IN CC2, 1, 0 )
4.Here are the final results:
5.Of course, you might also consider establishing a relationship between the two parameters:
However, the drawback is that if you create a slicer, it will only filter the contents of this table and those that belong to the same group as the selected content.
Please find the attached pbix relevant to the case.
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.