Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Referencing a Cell Value That Changes with Filters

Hi everyone,

 

I have a data set that tracks expenditures by month and I wanted to create a new measure where I divide a calculated column by the sum of the expenditures in the twelve month. The sum of the expenditures in the twelve month would be the total expenditures for the year. I could just input that number manually, but I use a slicer where I filter by two departments, so the value is changing. I was wondering how I would reference a specific cell (sum of expenditures in the twelve month) in a DAX expression. 

 

I tried using FILTER but it only calculated it for the twelve row. I need it to calculate for every month using the sum of the expenditures in the twelve month as the denominator value.

 

 

Thanks

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    I made simple samples and you can check the results below:

     

    Please feel free to correct me and provide more information if I have misunderstood you!

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    I made simple samples and you can check the results below:

     

    Please feel free to correct me and provide more information if I have misunderstood you!

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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