Filtered applied on column of Matrix shouldn't change its values.

[NidhiBhusari]

Below is the scenario and for this i need help in creating measure and implementing it.

Create a measure to count values of Test Variables and on applying filter of KPI Relevant as “True” then values of NN should not change .(Here N is count of "Test Variables")

compound_name	kpi_relevant	test_variable
FMF-T17319----	FALSE	T10
FMF-T17319----	FALSE	T40
FMF-T17319----	FALSE	T90
FMF-T17319----	FALSE	Tcure
FMF-T17319----	FALSE	Rebound Median
FMF-T17319----	FALSE	G'@1 % (cured)
FMF-T17319----	FALSE	G'@10 % (cured)
FMF-T17319----	FALSE	G'@100 % (cured)
FMF-T17319----	FALSE	tanD@10 % (cured)
FMF-T17319----	FALSE	Hardness Median
FMF-T17319----	FALSE	Elongation
FMF-T17319----	FALSE	MD050
FMF-T17319----	FALSE	MD100
FMF-T17319----	FALSE	MD200
FMF-T17319----	FALSE	MD300
FMF-T17319----	FALSE	Tensile
FMF-T17319----	FALSE	T10
FMF-T17319----	FALSE	T40
FMF-T17319----	FALSE	T90
FMF-T17319----	FALSE	Tcure
FMF-T17319----	FALSE	Rebound Median
FMF-T17319----	FALSE	G'@1 % (cured)
FMF-T17319----	FALSE	G'@10 % (cured)
FMF-T17319----	FALSE	G'@100 % (cured)
FMF-T17319----	FALSE	tanD@10 % (cured)
FMF-T17319----	FALSE	Hardness Median
FMF-T17319----	FALSE	Elongation
FMF-T17319----	FALSE	MD050
FMF-T17319----	FALSE	MD100
FMF-T17319----	FALSE	MD200
FMF-T17319----	FALSE	MD300
FMF-T17319----	FALSE	Tensile
FMF-T17319----	FALSE	T10
FMF-T17319----	FALSE	T40
FMF-T17319----	FALSE	T90
FMF-T17319----	FALSE	Tcure
FMF-T17319----	FALSE	Rebound Median
FMF-T17319----	FALSE	G'@1 % (cured)
FMF-T17319----	FALSE	G'@10 % (cured)
FMF-T17319----	FALSE	G'@100 % (cured)
FMF-H06660Y----	TRUE	T10
FMF-H06660Y----	TRUE	T40
FMF-H06660Y----	TRUE	T90
FMF-H06660Y----	TRUE	Tcure
FMF-H06660Y----	TRUE	Rebound Median
FMF-H06660Y----	TRUE	G'@1 % (cured)
FMF-H06660Y----	TRUE	G'@10 % (cured)
FMF-H06660Y----	TRUE	G'@100 % (cured)
FMF-H06660Y----	TRUE	tanD@10 % (cured)
FMF-H06660Y----	TRUE	Hardness Median
FMF-H06660Y----	TRUE	Elongation
FMF-H06660Y----	TRUE	MD050
FMF-H06660Y----	TRUE	MD100
FMF-H06660Y----	TRUE	MD200
FMF-H06660Y----	TRUE	MD300
FMF-H06660Y----	TRUE	Tensile

expected output :-

[NidhiBhusari · Accepted solution]

@amitchandak Thanks for replying...Its working.

[amitchandak]

@NidhiBhusari , best is create an independent table with true and false say kpi_relevant

Then NN will have not impact

n = calculate(countrows(Table), filter(Table, Table[kpi_relevant] = selectedvalues(Table[kpi_relevant]))

or you can try for NN with kpi_relevant from Table

NN = calculate(countrows(Table),removefilters(Table[kpi_relevant]))