PowerBI Measure to use multiple slicer selections in measure
Budget: €8 – €30 EUR
Hello,
I have already a few measures like this:
_IIIA3 = CALCULATE(
SUM(ZTA0153_LOT_CONS[THEORIC_DOSAGE]),
MATERIALS[MAKTX] = "CEM III/A 32,5 N-LH" ||
MATERIALS[MAKTX] = "CEM III/A 32,5 N-LH (na)"
)
and I want the users to be able to set the hard coded values via slicers.
So I created a (may be a table for each column will be needed) virtual table with the distinct values from the materials table and this will be used as the slicer selection (multiple values as well).
In the attached screen shots you see a "bookmark" selection pane where the user should choose the desired materials that will be summed up.
The 2nd shows the table where the measures will be shown.
Each slicer selection should of course not interact with the other.
I have already a few measures like this:
_IIIA3 = CALCULATE(
SUM(ZTA0153_LOT_CONS[THEORIC_DOSAGE]),
MATERIALS[MAKTX] = "CEM III/A 32,5 N-LH" ||
MATERIALS[MAKTX] = "CEM III/A 32,5 N-LH (na)"
)
and I want the users to be able to set the hard coded values via slicers.
So I created a (may be a table for each column will be needed) virtual table with the distinct values from the materials table and this will be used as the slicer selection (multiple values as well).
In the attached screen shots you see a "bookmark" selection pane where the user should choose the desired materials that will be summed up.
The 2nd shows the table where the measures will be shown.
Each slicer selection should of course not interact with the other.