Forum Discussion
Solved
ALLEXPECT ISSUe
I'm having trouble using the ALLEXPECT Function. I want to create a formula that will give me the total units ignoring all filters except for PD and CC. Here is the formula I came up with:
Units = CALCULATE(SUM(Packout[Piece Count]),ALLEXCEPT(Bridge,Bridge[CC],Bridge[PD]))
Data Model
Result:
The desired result is for each column in the units field to say 18518. Please let me know what I'm doing wrong or if I need to provide anymore information, thank you!
dyee4613 - The filter is being applied from G_L Account_No. That filters the bridge table and that, in turn, filters down the Packout table. I'm not sure what exactly you're trying to accomplish?
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
2 Replies
dyee4613 - The filter is being applied from G_L Account_No. That filters the bridge table and that, in turn, filters down the Packout table. I'm not sure what exactly you're trying to accomplish?
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.I fixed it. My issue was I had the data connection both ways. I switched it to one way and it fixed it.
