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.

Anonymous's avatar
Anonymous
Not applicable
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.