Forum Discussion
DAX Function to Countif
Hi, I've looked through a few suggestions for the above and tried to use them, but they didn't work. What am I doing wrong? I got an SQL Query to pull in Orders from our ERP system. Each ...
Nvm. Solved it with a simple vlookup
Hi,
Unfortunately this is only a small part of filter I will apply to the orders. I have a few more criteria to filter orders off by and I need this as a Calc column (not measure).
Some orders have 200+ parts on them and I need to include them as long as 1 part is a Stock item.
What I provided above is a calculated column, but it only operates on each row with now awareness of the table.
You could try creating a calculated table with Disctinct OrderId that creates aggreated columns. I think for that you can make use of SUMMARIZE().