Forum Discussion
RobX
Advocate I
Advocate IIf Statement With Two Tables
I have two tables with a one to many relationship. I'm trying to create a measure display true/false if the summed value in one table is greater than the summed value in the other table. I tried...
edhans
Community Champion
Community ChampionAmount A shoud not be an implict measure. So make Amount A be a measure like
Total Amount A = SUM(Table[Amount A])
Same for Amount B.
Then use
IF([Total for Amount A] < [Total for Amount B], "True", "False")
as your measure. That is really the same as wrapping your SUM()s above with a CALCULATE.
If you want actual tested code, please provide data per the links below. I cannot copy your images in to Power BI.
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.