Forum Discussion
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 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)
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
3 Replies
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
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
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
