Forum Discussion
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 ...
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
Anonymous
00_Category was not working if i select 2019 or 2018.. etc
00_Category = MAXX ( FILTER ( 'Age Category', 'Age Category'[Age] = [00_Age] ), [Category] )
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