Forum Discussion

databot_kd's avatar
databot_kd
Helper III
2 years ago

Measure Total not adding correctly in table


Hi community, 

hoping you can assist, my total in a table is not adding up correctly. 

All the row/line amounts are correct based on the below DAX. However, i believe the total is adding up values of 'type' Y and N. however it should only be adding up for 'type' 'N'. NOt sure how i can include this in my dax below. 

DAX:

                IF(MONTH([Selected To Date]) = 7, 0, TOTALYTD(SUM('GL History Periods'[glhp_amount]), 'Calendar'[date], FILTER('Calendar', 'Calendar'[date] <= [EoMSD]), "6/30") - [Movement])

I have tried using calculate and then filter in the SUM part however, does not change the total result. 

Thanks in advance. 

ced_f amitchandak Ahmedx Ritaf1983
Need Help
Show and Tell

3 Replies

  • Gabry's avatar
    Gabry
    Super User
    2 years ago

    This does not work?
      IF(MONTH([Selected To Date]) = 7, 0, calculate(TOTALYTD(SUM('GL History Periods'[glhp_amount]), 'Calendar'[date], FILTER('Calendar', 'Calendar'[date] <= [EoMSD]), "6/30") , type='N')- [Movement])

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi databot_kd ,

     

    You can create a new measure to be placed on the visual object instead of the previous one.

    previous measure=  IF(MONTH([Selected To Date]) = 7, 0, TOTALYTD(SUM('GL History Periods'[glhp_amount]), 'Calendar'[date], FILTER('Calendar', 'Calendar'[date] <= [EoMSD]), "6/30") - [Movement])
    new measure=SUMX(VALUES(Table[Type]), [previous measure])

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

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