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. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rbowen 

 

Kaviraj11 Thank you very much for your prompt reply. Allow me to share some content here.

 

Measure = 
IF(
    SELECTEDVALUE('Table'[Category]) = "A", // YourTableName[Category] = "A", 
    [TotalSales] -  [TotalCosts] + [TotalRebates], 
    [TotalSales] - [TotalCosts]
)

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rbowen's avatar
rbowen
Helper III
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.