Problem in Grand Total

[Shai_gokul]

There is two slicer 

One for Region

One for Product wise

price = IF(HASONEFILTER(Region),(CYPoint-PYPoint)*[Sales ],

SUMX( ALLSELECTED(Region),(CYPoint-PYPoint)*[Sales ])

ProctPrise = IF(HASONEFILTER(Product),(CYPoint-PYPoint)*[Sales ],

SUMX( ALLSELECTED(Product),(CYPoint-PYPoint)*[Sales ])

Measure is good for row wise in Table

but the total S

[v-yadongf-msft]

Hi @Shai_gokul ,

Can you describe the problem you are having in detail and tell me what's your expected output?

Best regards,

Yadong Fang

[Shai_gokul]

Expect output=10531

in Power BI out put is =15600

Beacuce i need total of selected in Region and Product 

But it takes the total using the Allselected values of region