topic Re: Measure showing similar row value in DAX Commands and Tips

Measure showing similar row value

Anonymous — Tue, 03 May 2022 12:45:17 GMT

Eligible Supply = CALCULATE (

SUM ( 'test data'[count] ),

FILTER (

ALL ( 'test data' ),

'test data'[Serial ID] <= MAX ('test data'[Serial ID] ) -1

&& 'test data'[Serial ID]

>= MAX ('test data'[Serial ID] ) - 24

)

)
Here's the data view

Value in the table

amitchandak

Re: Measure showing similar row value

philouduv — Tue, 03 May 2022 14:39:46 GMT

Hey Anonymous ,

If you try to sum the count for each vendor wit hcondition I advice you to create a calculated column

Eligible Supply =

CALCULATE (

SUM ( 'test data'[count] ),

FILTER (

ALL ( 'test data' ),
'test data'[Vendor Code] == Earlier('test data'[Vendor Code])
&&

'test data'[Serial ID] <= MAX ('test data'[Serial ID] ) -1

&& 'test data'[Serial ID]

>= MAX ('test data'[Serial ID] ) - 24

)

)

I assume that your condition is the red one and if it is accurate , you need to iterate on each vendor.

If this is not answering your problem , please explain what you are trying to do in your measure.

Best regards,

Re: Measure showing similar row value

Anonymous — Fri, 06 May 2022 06:33:25 GMT

Hi Anonymous ,

Please try modifying the measure as below:

Eligible Supply = CALCULATE (

SUM ( 'test data'[count] ),

FILTER (

ALLEXCEPT ( 'test data', 'test data'[Vendor Code]),

'test data'[Serial ID] <= MAX ('test data'[Serial ID] ) -1

&& 'test data'[Serial ID]

>= MAX ('test data'[Serial ID] ) - 24

)

Best Regards,

Jay