Forum Discussion

WiggityZwiggity's avatar
WiggityZwiggity
New Member
5 years ago
Solved

Using a Static Value in a Measure Breaks Visual Filters

I have a table visual filtered by slicers and report filters.  I've created a series of measures that evaluate each row within that data table by referencing a value within that table.  When I try to...
Need Help
  • WiggityZwiggity's avatar
    WiggityZwiggity
    5 years ago

    Thanks parry2k that worked.  Although I'm not sure I understand why.  I have the same issue when applying even simple calculations i.e. if I wanted to just subtract a value from [OrderCount] the same thing occurs.  So would I have to add an IF statement like that to evaluate if it is not blank?  I think that's where I get tripped up.  

parry2k's avatar
parry2k
Super User
5 years ago

WiggityZwiggity because you are now returning the value in this new measure, try it like this

 

IF([OrderCount]>1,"Active,IF (NOT (ISBLANK([OrderCount]),"Inactive"))
WiggityZwiggity's avatar
WiggityZwiggity
New Member
5 years ago

Thanks parry2k that worked.  Although I'm not sure I understand why.  I have the same issue when applying even simple calculations i.e. if I wanted to just subtract a value from [OrderCount] the same thing occurs.  So would I have to add an IF statement like that to evaluate if it is not blank?  I think that's where I get tripped up.