Forum Discussion

MrWLJ71's avatar
MrWLJ71
Icon for Helper I rankHelper I
5 years ago
Solved

Filter value totals based on slider or option selections

Firstly I must point out I am an absolute newbie when it comes to Power BI, so please be patient! I am so new in fact I hardly know how to ask the question for what it is I am wanting to achieve, so...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

The answer is simply no, the same measure can't change dynamically when you change the field filter. However you can add a new measure to the table

And I would recommend that you create a new page with the new measure and new parameter, it would make more sens

here is the formula

Est Replace Cost running total in StartRank =
CALCULATE(
    SUM('tblLCAM'[Est Replace Cost]),
    FILTER(ALL(tblLCAM),
        ISONORAFTER('tblLCAM'[STRATrank], MAX('tblLCAM'[STRATrank]), DESC)
    )
)
 
MrWLJ71's avatar
MrWLJ71
Icon for Helper I rankHelper I
5 years ago

Hi Amine

I really dont follow that. I created a new page as you suggested. The table is not displaying what I expected.

 

  • MrWLJ71's avatar
    MrWLJ71
    Icon for Helper I rankHelper I
    5 years ago

    Amine

    Thank you, from the bottom of my heart I truly appreciate a) your time, b)your effort, c)your patience and d)your kindness in assisting me with this! We got there !!!

     

    I have marked this as resolved.

     

    I am very grateful

  • MrWLJ71's avatar
    MrWLJ71
    Icon for Helper I rankHelper I
    5 years ago

    Thank you again Amine. I have used your guidance to create the table correctly as per what I needed in the first instance, so thank you very much. 

     

    Before I mark the solution, knowing that I cannot have a dynamic table in the way I would like, what code do I need to enter into the measure (as a new measure) for each site, so I can replicate the table on a separate page per site?

     

    Thank you

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Private

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Welcome