Field Paramters: Filter another Table Visual by the field parameter selection

DAX DAX Calculations
1

I have a Field parameter defined for single selection of various KPIs:

image
image1977×235 39.4 KB

SMMD FPARAM_KPIs_FL = {
(“Functional Locations”, NAMEOF(‘SMMD Measures GENERAL’[Count Functional Locations]), -400 , “Attributes”, 1),
(“Production Units (MTBF on L3 or L4)”, NAMEOF(‘SMMD Measures GENERAL’[Count FL Production Units (MTBF on L3 or L4)]), -490,“Attributes”, 1),
(“Level 3 MTBF-relevant”, NAMEOF(‘SMMD Measures GENERAL’[Count FL3 with MTBF (Filled Down)]), -480,“Attributes”, 1),
(“Level 4 MTBF-relevant”, NAMEOF(‘SMMD Measures GENERAL’[Count FL4 with MTBF]), -470,“Attributes”, 1),
(“A”, NAMEOF(‘SMMD Measures GENERAL’[Count FL A]), -460,“Attributes”, 1),
(“B”, NAMEOF(‘SMMD Measures GENERAL’[Count FL B]), -459,“Attributes”, 1),
(“C”, NAMEOF(‘SMMD Measures GENERAL’[Count FL C]), -458,“Attributes”, 1),
(“Production Units A or B with MPlan Items or Task List Ops %”, NAMEOF(‘SMMD Measures GENERAL’[DQC_Rate FL Production Units A&B with Maintenance Plan Items or Task List Operations on FL or EQ %]), -450, “Data Quality - Critical”, 2),
(“Production Units A or B with MPlan Items or Task List Ops”, NAMEOF(‘SMMD Measures GENERAL’[Count FL Production Units A&B with Maintenance Plan Items or Task List Operations on FL or EQ]), -449, “Data Quality - Critical”, 2),

…

}

I have another table with many measures and therefore showing a lot of rows.
My goal would be now to filter this table visual by the field parameter selection, that only the entries where the Field parameter selection >0 remain

Example:

I have 66.574 items in this table and there shall only remain these 1.160 visible, which fulfill the selected field parameter criteria “Level 4 MTBF-relevant”

Table with Values:

image
image1343×435 31 KB

Table setup:
image

My previous approach was always to get the NAME of the Field parameter selection and write another measure, where I check for the text of the field parameter selection and enter the exact same measures again.
But this is too vulnerable, as when the Field Parameter Entry name changes, the new Measure does not get triggered
Here an Example from anothe rcheck measure

image
image993×592 42.2 KB

I’d just love to have a new measure as simple like SELVAL = SELECTEDVALUE(FPARAM_KPIs_FL[…]) - so the REAL value of 1.164
and just apply this as a filter on the visual level in the filter pane and check for >0

I already asked Data Mentor and it fullfiled my wish - but just in theory, as it just made something up :sweat_smile:

image
image1447×1042 78.3 KB

Thanks a lot,
Alex

2

Hi @AlexRobe ,

check this

and add additional what you need.

3

Thanks for your hint.
Sorry if I wasn’t clear enough but I need the numeric OUTPUT VALUE of the selected measure (in my example the number 1003) and not the selected Measure name

image
image2210×947 171 KB

Just in case you need the NAME of the selection you can achieve this much easier than described in SQLBI just by typing

SelectedParameter = MIN(Parameter[Parameter])

Thanks!