Forum Discussion

rbowen's avatar
rbowen
Helper III
2 years ago
Solved

Create Measure With Filter Conditions

I'm trying to create a measure that uses some conditions for the final result that will included in a table visual. I have 3 previously created measures, one for Sales, one for Costs and one for Reba...
Need Help
  • rbowen's avatar
    rbowen
    2 years ago

    Thank you for the reply Nono. I gave up on this approach and went a different direction by restructuring some of the data and altering some of the relationships. 

Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

Hi,

 

Try this: 

IF(

SELECTEDVALUE([Category]) = "A", [TotalSales] -  [TotalCosts] + [TotalRebates], [TotalSales] - [TotalCosts])
rbowen's avatar
rbowen
Helper III
2 years ago

Thanks Kaviraj11, but this doesn't work either. I still get the same red underline under [Category] with the same error message. I've also tried using the aggregator SUM but same problem. Seems to be related to using a column name with the IF statement in combination with the measures. The syntax is almost certainly incorrect but I'm not sure what the correct syntax should be.