Forum Discussion
Cost allocation with two fact tables
Hi Lars_Denmark ,
In order for your allocation % to also respect the LineNo filter for your % of sales calculation you can tweak the two dax measures as follows:
First, modify your denominator of the % of sales measure by including all function to ignore filter for the LineNo field.
The above measure is then used in the % calculation in your data model.
Also, another part you need to modify is the following measure by including the yellow highlighted part for the same reason as above.
The resultant output produces the consistent output for sales % allocation respecting also the LineNo field.
I attach the updated pbix file.
Best regards,
You would need to combine these into one table and distriubte the total sales and profit proportionality by number of lines or something on those lines.
That is a high level thought on this, but to implement in a chat like this would not be possible.