Forum Discussion
Solved
Mailing list from Power Pivot
I have 3 tables: a dimension table with suppliers, a dimension table with SKU's, a fact table of purchase orders. (See simplified data below and in attached workbook). tSuppliers: tSKUs...
As a comment, that's a best practice to hide fields on "many" side of relationship and don't use them in reports.
Slightly modified Riny_van_Eekelen solution, you may use measures
Total SKUs:=CALCULATE( COUNTROWS( tPOs ), CROSSFILTER( tSKUs[SKU], tPOs[SKU], Both ) ) SKUs:=CALCULATE( CONCATENATEX(tSKUs, tSKUs[SKU], ", "), CROSSFILTER( tSKUs[SKU], tPOs[SKU], Both ) )to have PivotTable in bit different form
As a comment, that's a best practice to hide fields on "many" side of relationship and don't use them in reports.
Slightly modified Riny_van_Eekelen solution, you may use measures
Total SKUs:=CALCULATE( COUNTROWS( tPOs ), CROSSFILTER( tSKUs[SKU], tPOs[SKU], Both ) )
SKUs:=CALCULATE( CONCATENATEX(tSKUs, tSKUs[SKU], ", "), CROSSFILTER( tSKUs[SKU], tPOs[SKU], Both ) )to have PivotTable in bit different form
SergeiBaklan Thank you for the tips.
Thank you both for your help!
I'm just not sure which answer to mark as best response now 🙂
