Filter IF...

[Anonymous]

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 says "No Stock" only Sum [SO Net] <= 25000

So Only sum [SO Net] <=25000  if it says No Stock, otherwise Sum even if [SO Net] is > than 25000

The meassure should be calculated a level by Year, Quarter,  Product Group, End User Country, and finally End User (That is why I used the Summarize function in the code below.

Can you help me please??!!

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]
        ),
        [SO Net] <= 25000
    ),
    [SO Net]
)

[MFelix]

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]

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]

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?

[selimovd]

Hey @Anonymous ,

how is the relationship between the tables 'DB' and 'POS DB'?

If we should filter if 'DB'[Stock] says "Stock" or "No Stock" we need to know how these tables are connected and also how the data looks like.

Make it easy for us and we can help you.

Best regards

Denis

[Anonymous]

Hi! Sorry for my mistake, I just edited the post... Its all the same data base. Sorry!

[aj1973]

Hi @Anonymous 

Your request is missing information!

Can you share a sample Pbix?