Forum Discussion

Gyuzal0997's avatar
Gyuzal0997
Regular Visitor
4 years ago
Solved

Row subtotal is incorrect

Hi, everyone.   I am facing the problem of displaying row subtotal value correctly.  In my data I have a hierarchy where there are  outlet codes connected with a person or trade marketer. The goal...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Gyuzal0997 ,

    Please have a try.

    Select the only column in the table that has no duplicate values, such as a date column, or create an index column.

     

    Then create a measure based on [sales fact].

    var _b = SUMMARIZE('sales','sales'[date] or index column,"aaa",'sales'[sales fact])
return
IF(HASONEVALUE('sales'[date] or index column),'sales'[sales fact],SUMX(_b,[aaa]))

     

    If I have misunderstood your meaning, please provide more details with screenshots.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

Gyuzal0997 , You have force visual group by the context in the formula . I should be some common dimesion column

 

Sumx(Values(Table[Column]), IF ( DSDSalesData > 0, DSDSalesData, Alternative ) )

 

 

Use summarize if there are more than one column

refer if needed https://www.youtube.com/watch?v=ufHOOLdi_jk