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 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

 

 

  • 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])
)

2 Replies

  • 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])
)
  • sanalytics's avatar
    sanalytics
    Icon for Super User rankSuper User
    2 years ago

    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