Forum Discussion

Shai_gokul's avatar
Shai_gokul
Frequent Visitor
3 years ago

Problem in Grand Total

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...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

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's avatar
    Shai_gokul
    Frequent Visitor
    3 years ago

    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