Forum Discussion
naoyixue1
Post Patron
4 years agohow 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,...
- 4 years ago
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
naoyixue1
Post Patron
4 years agoHey all,
Any thoughts? Or I should go the other way to do that summary. Thanks for your help!