Forum Discussion
Aggregate based on category using column from other table
My Database schema looks like this,
I am trying to find categories that were delivered late.
I created a measure to find the delay in delivery (days).
But while plotting, I am stuck here,
I need something like ,
Any help is highly valued and appreciated.
1 Reply
Lots of ambiguity here. Orders can contain multiple products. These products can be in multiple categories.
From your data model you can see that orders cannot influence categories. So you need to use measures that use TREATAS (for example) to project filters across these crossfilter walls.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
