Forum Discussion

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

2 years ago

Units_Department_Customer = 
CALCULATE(
    SUM(SalesInvoice[Units]),
    TREATAS(VALUES(Product[Class]), SalesInvoice[Class]),
    ALLEXCEPT(Product, Product[Department]),
    ALLEXCEPT(Customer, Customer[Customer])
)