Forum Discussion

matthewho's avatar
matthewho
Regular Visitor
2 years ago
Solved

Help creating a dax measure

Hi all, I am currently pretty new to Dax/PowerBi and am having trouble writing a Dax.   I want my dax to correctly calculate and filter units by both department and customer.   I have three table...
  • aduguid's avatar
    aduguid
    2 years ago
    Units_Department_Customer = 
CALCULATE(
    SUM(SalesInvoice[Units]),
    TREATAS(VALUES(Product[Class]), SalesInvoice[Class]),
    ALLEXCEPT(Product, Product[Department]),
    ALLEXCEPT(Customer, Customer[Customer])
)
aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago
Units_Department_Customer = 
CALCULATE(
    SUM(SalesInvoice[Units]),
    TREATAS(VALUES(Product[Class]), SalesInvoice[Class]),
    ALLEXCEPT(Product, Product[Department]),
    ALLEXCEPT(Customer, Customer[Customer])
)