cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dixypbi
Frequent Visitor

Measure showing similar row value

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
Data.png


 Value in the table

Incorrect Value.png

@amitchandak 
1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @dixypbi ,

 

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
Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @dixypbi ,

 

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
Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
philouduv
Resolver II
Resolver II

Hey @dixypbi ,

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,

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.