Forum Discussion

nanat's avatar
nanat
Frequent Visitor
8 years ago
Solved

Adding Filter on Countrows and Relatedtable

Hi,   I need some help please. I have 2 tables (All Customers, Product Items). These 2 tables are linked by the unique Customer ID with All Customers as the 1 side and Product Items as the many sid...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    nanat

     

    I think something along these lines should work

     

    Product Order per Customer =
CALCULATE (
    DISTINCTCOUNT ( 'Product Items Internal ID'[Products] ),
    'Product Items Internal ID'[status] = "invoiced"
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

nanat

 

I think something along these lines should work

 

Product Order per Customer =
CALCULATE (
    DISTINCTCOUNT ( 'Product Items Internal ID'[Products] ),
    'Product Items Internal ID'[status] = "invoiced"
)