filter didn't reflect

[ddd111rgg23]

hello 

i would like to ask what the possible issues that cause filter didn't match with my select < 

i trying to add different shared file with different value but when i filter it seems same result , and some KPI didn't appear 

Thank You 

[Venkat7]

are you written set expression and using identifier 1 ? ensure   if you are using 1 it will not reflect any selections 

[Venkat7]

if you are filter data in expression that data also not reflect 

[martinpohl]

you can ignore selections in fields by editing your expression with set analysis eg {1} for ignore all selection or {<Field1, Filed2>} for ignore selections in dedicates fields.

Also alternate state could be possible, you can see them on the settings of the KPI-object

Regards

[anat]

You may bypassed filtered dims in expression

[Venkat7 · Accepted solution]

could you please describe more 

i mean exact your requirment for my understanding purpose without proper requirment I can't help you

[ddd111rgg23]

i really appreciate your help, 

more datils 

this is my set analysis without {1}:

Count({<Flag = {'Compliance'},[KPI Name] = {'Compliance Maturity Level'}, Results = {'Yes'}>}Results)
/
Count({<Flag = {'Compliance'},[KPI Name] = {'Compliance Maturity Level'}>}Results),

and this is my script :

Concatenate(Compliance)
LOAD
"KPI Name",
SubPolicy,
policy,
"Year",
Quarter,
Results,
F7,
Comments,
'Compliance' as Flag,
' LLC ' as CompanyName
FROM [lib://AttachedFiles/GRCC Dashboard - Compliance inputs - -Aero.xlsx]
(ooxml, embedded labels, table is [Compliance Maturity Level]);

, and this is the files i make the filter by companyName from it   

thank you 

[ddd111rgg23]

thank you