Forum Discussion

sajal161292's avatar
sajal161292
Icon for Helper V rankHelper 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...
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