Filter using measure

[Anonymous]

Hello All,

Need help in undestanding the filter function and apply for my use case.

I have 2 months of sales data (Jan and Feb) having both postive and negative values (for few rows) and i want to filter the visual to show rows having positive values only.

However, issue pops up in cases where Jan month is +ve and Feb month is -ve or vice-versa.

In short, how can i apply sales measure as a filter and show only +ve rows and apply across any/both months.

ignore rows where it has got both +ve and -ve values in the different months.

Please help.

[amitchandak]

@Anonymous , You can create a positive measure like

sumx(table, if(table[value] =abs(table[Value]),Table[Value]))

[CheenuSing]

Hi @Anonymous 

Can you upload the data in One Drive / Google Drive and share the link. 

Also for the sample data what is the ouput expected.

Best Regards

CheenuSing

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can try.

Measure = If ([Sales] > 0 , [Sales] , BLANK())

Also,

You can create a Visual Filter

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)