Forum Discussion
Filter IF...
Hello! I have this dax code, I need the meassure to Sum all the SO Net ( [SO Net] is a meassure = Calculate(Sum(POS DB'[SO Net)) ) of all the rows that say "Stock" ( 'POS DB'[Stock] ) but if it ...
Mfelix thanks for you time and response
Indeed, [So Net] is a meassure
How can I Filter IF??
I need the meassure to Sum all the SO Net ([SO Net]) of all the rows that say "Stock" ( 'POS DB'[Stock] ) but if it says "No Stock" only Sum [SO Net] <= 25000
So Only sum [SO Net] if it says Stock, otherwise Sum even if it is > than 25000
Hi Anonymous ,
Since you need to do addtionall filtering on your data based on a column that is not on the summarize can you please share some sample data?