Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

The question is that you are not adding the value on the table summarization so you are not filtering the values you need try the following code.

 

Meassure =
SUMX (
    FILTER (
        SUMMARIZE (
            'POS DB',
            'POS DB'[Year],
            'POS DB'[Quarter],
            'POS DB'[Product Group],
            'POS DB'[End User Country],
            'POS DB'[End User Name],
            "@SONET", [SO Net]
        ),
        [@SONET] <= 25000
    ),
    [@SONET]
)

 

Be aware that I'm assuming that by the format [SO Net] is a measure in your model.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

     

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      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?