Forum Discussion
Cost allocation
A correction to my previous solution attempt, now all numbers match with what was requested.
I had overlooked a request on the filtering a single team
File attached and a couple of results here follow
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hello Jay20024
a relationship between the two tables would be a many to many, so I avoided that overall
Here are the tables I loaded, based on your sample
fact
dimension
Model (no relationship)
Attached the pbix I generated
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
A correction to my previous solution attempt, now all numbers match with what was requested.
I had overlooked a request on the filtering a single team
File attached and a couple of results here follow
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI