Filter data based in table on measure

[arusanah]

Hi ,

Is it possible to filter Data in table report based on measure value ?

my Requirement is to eliminate rows where sum(M1+M2)=0

Dim	M1	m2
AA	100	344
BB	655	33
CC	333	-333
DD	44	-44
EE	234	4432
FF	323	-323
GG	3534	666

e.g : in above example  I  want to Hide( Dim CC,DD,FF as sum of M1 & M2 =0 for these dim rows.) in my report.

Any help is highly appreciated.

[isingh30]

Eliminate means you want to remove them permanently or want to hide them?

[isingh30]

LOAD Dim,

     M1,

     M2

FROM

(ooxml, embedded labels, table is Sheet2)where (M1+M2)<> 0;

[arusanah]

Hi  Ishtdeep,

I want to hide them in my report.

[isingh30]

Above is the answer. Let me know.

[arusanah]

But there are other visualizations which are using same dimension, and if we restrict at load we gonna lose these dimension values permanently.

[isingh30]

That means you need solution at UI level. Correct?

[ogster1974 · Accepted solution]

Make your dimension a calculated one based on your condition you want to excluded

If(AGGR(SUM(M1)+SUM(M2),DIM)=0,NULL(),DIM)

Then exclude null values on the dimension.

Regards

Andy

[isingh30]

=if (SUM(M1)+ SUM(M2) <> 0,Dim)

[arusanah]

Thank you Andy !!