Forum Discussion
If Statement With Two Tables
Very hard to understand the requirements without sample data and expected results, and there is no indication of what the evaulation context is here. Sample data would be great. Without that, the only thing I can suggest is wrap both SUM() functions with CALCULATE() and see if the context transition gets you what you need. If not, provide data please and expected results.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Here's a sample.
TableA
TableB
I want to create the table below with the measure "A Less Than B"