Forum Discussion

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
5 years ago
Solved

Dynamic measure selection

Hi all,   I am trying to allow my users to compare overdues over the course of the month days.   I could easily achieve the above by creating seperate measures for each month as shown in the scre...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Mous007 , no worries, I come to your rescue, with the LEGEND of line graph ğŸ˜‚

     

    I presume your data is more or less like this,

    The measure can be simplified to

    Total Overdue = SUM( Consolidated[Overdue] )

     

    You might want to refer to the attached file for more details. 

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
5 years ago

Thank you all for your replies.

 

CNENFRNL your solution is actually what i am looking for for a first draft and it does the job indeed. I have no idea why i haven/t taught about it as it is fairly simple.

 

Thank you all again for the support