I’m trying to write a measure that sums a column filtered by multiple criteria. My data has a column with different categories. I want to sum a payment column only if the individual row has two ore more of the following categories:
So far I have written the following:
Final COG = CALCULATE([Commission COG],FILTER(AdvancedMD_DATA, AdvancedMD_DATA[Visit Primary Carrier Category] = "BCBS - BLUECROSS/BLUESHIELD" && AdvancedMD_DATA[Visit Primary Carrier Category] = "MD - MEDICARE"))
The problem I am having is that it seems to filter most based of the first expression but then stops. I need it to take in to account both or more. Any help would be much appreciated.