Forum Discussion
naoyixue1
Post Patron
Post Patronhow to summarize one table whose data are from two fact tables
Hey there, Let me briefly introduce the background as below. Originally, we only calculate the difference in units and % (production against forecast) as our metrics. But it might mislead us,...
Ok, see if this works.
Count Items w/forecast = COUNT ( 'Forecast Fact'[Item] )Above Forecast = COUNTROWS ( SUMMARIZE ( FILTER ( 'SKU List', [Production] >= [Sum Forecast] && NOT ( ISBLANK ( [Production] ) ) ), 'SKU List'[Item], 'Vendor Lookup'[Vendor] ) )I've attached the PBIX file
naoyixue1Post Patron
Post Patronlittlemojopuppy Sure. Here you go. I put all related table and measure there. Now, I just want to show below in the summary table.
1: How many items we forecasted
2: How many items forecast is equal to the production
Really appreciate your help!