filter

[omergencay]

Hi, I have a problem. I am trying to filter my table with two of its ingredients are "the stock name" and "stock selling profit marge". The Stock name measure is written above "ABC/123" and the stock selling profit ratio measure is written above " 1.2". 

I wanna do a filter like Filter( ratio, ratio >0,00).  But while I am trying to do that, ı couldn't select the "ratio table." What is the problem you think?

Then ı wanna calculate an "average stock selling profit marge" without negative ( <0,00)  and neutral numbers ( 0,00)

[Anonymous · Accepted solution]

HI @omergencay,

You can write a measure to check current value and return tag, then drag this measure to visual level filter to filter matched records.

Sample measure:

Filter Tag =
VAR curr =
    SELECTEDVALUE ( Table[stock selling profit marge] )
RETURN
    IF ( curr > 0 && curr - INT ( curr ) = 0, "Y", "N" )

Regards,

Xiaoxin Sheng

[omergencay]

@Anonymous

Filter Tag1 =
VAR curr =
SELECTEDVALUE ( 'Export Worksheet (eklenti)'[RASYO] )
RETURN
IF ( curr > 0 && curr - INT ( curr ) = 0; "Y"; "N" ) 

I wrote this formulate and then my conclusion occurs just like that in table visual:

Filter Tag            Ratio

N                        811,83

[Anonymous]

Hi @omergencay,

You can direct drag this measure to visual level filter of a table visual and filter 'Y' result.

In addition, your table visual need a category column to expand ratio result.

Regards,

Xiaoxin Sheng