Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago
Solved

Subtotal text value as dynamic

Hi Team, Is it possible to change the subtotal labels as dynamic. Currently there is no option to change subtotal labels to dynamic based on the values. Can you all help on this.     
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi prakash11440278 ,

     

    Based on your description, you can use INSCOPE() to create a measure as follows.

    For example, I just want the subtotal of column "C2" to be displayed.

    Measure = IF(ISINSCOPE(test_subtotal[C2]),SUM('test_subtotal'[Value]))

    Result:

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago

Hi amitchandak ,

You mean to say this feature is not available in Power BI as of now? Any workaround for this.