except()
1 Topic
Except Function to get the list of values
Hello, Being a beginner in PowerBI and coming from Tableau background, I am stuck and unable to understand the below. I have created the DAX calculated column to get the list of items present only on a given date and not present on another given date. PO Added = VAR CD1 = SELECTCOLUMNS( CALCULATETABLE( VALUES('All Netstar Inventory'[PO#]), 'All Netstar Inventory'[Cut Date] = 'All Netstar Inventory'[CutDate_1], REMOVEFILTERS('All Netstar Inventory'[PO Removed]) ), "PO", 'All Netstar Inventory'[PO#] ) VAR CD2 = SELECTCOLUMNS( CALCULATETABLE( VALUES('All Netstar Inventory'[PO#]), 'All Netstar Inventory'[Cut Date] = 'All Netstar Inventory'[CutDate_2], REMOVEFILTERS('All Netstar Inventory'[PO Removed]) ), "PO", 'All Netstar Inventory'[PO#] ) RETURN EXCEPT(CD1, CD2) 1. If I use this field in a table chart, I am getting all the POs including a blank value rather than getting only the POs present in CD1. 2. If I create a count measure on top of this calculated column, the count comes correct. 3. Also, if run the above formula using the DAX Query view using the Evaluate command, there also it gives the list of POs only present in CD1. So, I am not able to understand why 2 & 3 are working correctly but 1 is not working correctly. How can I fix 1 to get the list of POs correctly. Thank you!Solved4KViews0likes11Comments