Forum Discussion

omergencay's avatar
omergencay
Regular Visitor
8 years ago
Solved

filter

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...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
omergencay
Regular Visitor
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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