Forum Discussion

vengadesh_p's avatar
vengadesh_p
Icon for Helper II rankHelper II
3 years ago
Solved

Create Calculated Column based on filter Selection

Hi All,   I have data like below table Period Year Value 2010 13 2011 12 2012 12 2013 6 2014 18 2015 15 2016 11 2017 19 2018 8 2019 17 2020 16  ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi vengadesh_p ,

    Please update the formula of measure [00_Category] as below and check if it can return the correct result. Please find the details in the attachment.

    00_Category = 
VAR _age = [00_Age]
RETURN
    MAXX ( FILTER ( 'Age Category', 'Age Category'[Age] = _age ), [Category] )

    Best Regards

lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
3 years ago

You can't achieve it. Calculated columns are calculated on model refresh and therefore don't know anything about the filter context.

 

What you can do is to use some iterator functions like SUMX. What should the output be and where?