Forum Discussion
Dunner2020
Post Prodigy
Post ProdigyCreating filter as measure
Hi there, I have a fact table which contains data about the sales such as what was sold, how much sold, when sold, who sold, how many customers bought particular sold, so on and so forth. You ca...
Your error is that you can't return a table as a scalar value. You have to aggregate it first. The most common way is to wrap your FILTER in a COUNTROWS ( FILTER(Table, Table[Column] >5))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeYour error is that you can't return a table as a scalar value. You have to aggregate it first. The most common way is to wrap your FILTER in a COUNTROWS ( FILTER(Table, Table[Column] >5))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat