DAX shows different values on main visual and shows different values on Drill through page

[riteshmen]

I've below DAX- 

Pr Yr loss GP_Month YY (new) =
VAR PriorFYDates =
DATESBETWEEN (
'Calendar'[Date],
STARTOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date], "3/31" ), "3/31" ),
ENDOFYEAR ( PREVIOUSYEAR ( 'Calendar'[Date], "3/31" ), "3/31" )
)

VAR LossMakers_AllDiv =
FILTER (
SUMMARIZE (
ALLSELECTED ( 'GL+GF'[Customer Group] ),
'GL+GF'[Customer Group],
"GP_PY",
CALCULATE (
SUM ( 'GL+GF'[GP] ),
PriorFYDates,
REMOVEFILTERS ( 'GL+GF'[Division Code] ) -- or REMOVEFILTERS('GL+GF'[Division Code])

)
),
[GP_PY] < 0
)

VAR CustList =
SELECTCOLUMNS ( LossMakers_AllDiv, "Customer", 'GL+GF'[Customer Group] )

RETURN
CALCULATE (
SUM ( 'GL+GF'[GP] ),
DATESYTD ( 'Calendar'[Date], "3/31" ),
TREATAS ( CustList, 'GL+GF'[Customer Group] ) 
) 

This gives a correct value on the visual where I'm using it against division, but when I use the same DAX in the drillthrough page, it shows different values. I drill through, I'm using Division Code, Customer Group, Country, MonthYY columns, along with the DAX

[v-pnaroju-msft]

Hi riteshmen,

Kindly provide some sample data which explains your problem or question clearly in a simple and neat format, not as an image. This will help us to understand and solve the issue more effectively. Please ensure the data is relevant, does not have any sensitive details, and is connected to your problem. Also, let us know what result you expect from this sample.

Thank you.

[v-pnaroju-msft]

Hi riteshmen,

Please share some sample data that shows your problem or question clearly in a simple and organized way (not as an image). This will help us understand and solve the issue better. Make sure the data is relevant, does not have any sensitive information, and is related to your problem. Also, please tell us what result you expect from this example.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @danextian, for your response.

Hi riteshmen,

We appreciate your question on the Microsoft Fabric Community Forum.

We kindly request you to provide sample data that clearly demonstrates your issue in a structured format (not as an image) to help us understand and resolve the matter. Please ensure that the data is relevant, free from any sensitive information, and directly related to the issue. Additionally, please share the expected outcome based on the given example.

Thank you.

[danextian]

Hi @riteshmen 

There maybe filters applied in the main page but not in drillthrough or the other way around. It is hard to figure out what could be the cause without a "sample" pbix.