Forum Discussion

larbpup's avatar
larbpup
Frequent Visitor
3 years ago
Solved

Help with Crossfiltering across multiple tables

Hello, I have a fact table of forecasted sales orders and a table of part numbers with corresponding production rates. I would like to calculate the amount of total production hours needed per month...
  • some_bih's avatar
    some_bih
    3 years ago

    Hi larbpup I personally do not use bidirectioanal relationship as ambigious result could emerge, I rather rework model if possible. Still, with my little knowledge of this area, could you please check part ,BOTH)) in your crossfilter function. Maybe this could help in debuging your wanted output, give a try to change this part.  Great link for crossfilter is below, with other usefull link

     

    https://dax.guide/crossfilter/ 

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi larbpup I personally do not use bidirectioanal relationship as ambigious result could emerge, I rather rework model if possible. Still, with my little knowledge of this area, could you please check part ,BOTH)) in your crossfilter function. Maybe this could help in debuging your wanted output, give a try to change this part.  Great link for crossfilter is below, with other usefull link

 

https://dax.guide/crossfilter/