topic Help creating a dax measure in DAX Commands and Tips

Help creating a dax measure

matthewho — Wed, 26 Jun 2024 09:53:34 GMT

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 tables
SalesInvoice, Product, and Customer.

Within Product there is Department and Class.

Within SalesInvoice there is Class and Customer

Within Customer there is Customer

This is my current dax that is not working..

Units_Department_Customer = CALCULATE(
SUM(SalesInvoice[Units]),
FILTER(
SalesInvoice,
RELATED(Product[class]) = F_SalesInvoice[class],

--part that I don't know how to do
),
ALLEXCEPT(Product, Product[Department]))

Thanks

Re: Help creating a dax measure

sanalytics — Wed, 26 Jun 2024 10:18:58 GMT

matthewho
Please provide some dummy data along with your model. Also, provide your expected output so that we can try from our end.

Regards

sanalytics

Re: Help creating a dax measure

aduguid — Wed, 26 Jun 2024 12:39:18 GMT

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