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(HASONEFILTER(Product),(CYPoint-PYPoint)*[Sales ],
SUMX( ALLSELECTED(Product),(CYPoint-PYPoint)*[Sales ])
 
Measure is good for row wise in Table
but the total S
Need Help

2 Replies

  • 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