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 all,
I have created a measure (OrdersInFull) that gets a count of how many orders are "In Full". The measure works fine until I add "ProductName" from the product dimension (one to many relationship Product -> Sale). When I add "ProductName" to the table, the rows increase to display every possible product for every line in the Sale table. Why does this happen?
Calculation for the measure (probably whats causing the issue ) is also in the screenshot below. On the left you will see the table without the "ProductName" field, displaying correctly. The table on the right shows what happens when I add ProductName. Any help on this is much appreciated.
You're adding 0 to every count in that measure, so there are no blank values. Every product gets a 0, so it has to display.
Proud to be a Super User!
Thanks for that. I was sure this is intended behaviour. However, if I remove the zero (allowing blanks) then if I have a similar table to my original post except without the saleLine included, then the table only shows orders where "InFull" = "Y", I need it to show all orders regardless of if its infull or not. Is there any way I can improve my measure to do this? Thanks again for your help.
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 |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |