Forum Discussion
If Statement Working With Two Seperate Database Tables
Hello Everyone, I have an request that has been causing me some trouble on how to resolve. I have a need for a new column to be created which uses an If or Case statement where possible. ...
Hello @rajulshah, the formula is accepted in PowerBI - thank you for that answer, however I am now getting the following message.
A single value for column ‘ID’ in table ‘SYSADM CUSTOMER’ cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
In our database we have a connection where the tables - Customer (one) can have Orders (many) - anyway to get around this or are we out of luck? Cheers.
Maverick_BI
I would need to look at the data to see why is it giving error because we have already used aggregation in the measure.