Forum Discussion

sajal161292's avatar
sajal161292
Helper V
8 years ago

To calculate the total dynamically

Hi,

 

I am stuck up in calculating a running total for one of my reports.In the image given beloww i would basically liske to adjust the on hand demand like the one shown below.

 

Presently it is taking the values that are coming from the database and then adding it up.I have used a calculated measure for doing up the cumulative calculation.

 

 

Any help would be much appreciated!!

 

17 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi sajal161292,

     

    Please share the sample pbix file to test, it will be help to analysis your situation.(if your file contains some privacy data, you only need to share part of them or use original structure to create some fake data)


    BTW, measures which works on specific filters normally not work properly on total row. In my opinion, you need to add a filter to check on total row and write a specific formula who works on total row.

     

    For example: 

    checkrow =
IF (
    COUNTROWS ( table ) <> COUNTROWS ( ALLSELECTED ( table ) ),
    "normula row",
    "total row"
)

     

    Regards,

    Xiaoxin Sheng

    • sajal161292's avatar
      sajal161292
      Helper V
      8 years ago

      Hi,

       

      Thank you for your reply.

      My pbix file is having some private data.So is there any way to share it with you by hiding the data that is private?