Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 can call that fact table contains raw data. Now I want to apply some exclusion rules on the data (exclude some data based on some rules). For example:
1) exclude sale information about product that few customers (i.e. 5) have bought.
2) exclude sale information about the product that was sold 'online'.
Initially, I thought to create two separate filters containing each rule and then apply to fact table of sales. So, I created a measure something like the following:
filter 1 =
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |