Forum Discussion
Solved
DAX filter with condition
Hi Friends, I need a help writting this measure. Here is a sample data. Plan Year Amt Plan 1 2019 30 Plan 1 2020 40 Plan 1 2021 15 Plan 2 2015 20 Plan 2 2018 20 Pla...
hi amit_msmba
try to plot a card visual with the measure like this:
YearList = VAR _plan = MINX( FILTER(TableName, TableName[Amt]>35), TableName[Plan] ) VAR _year = CALCULATETABLE( VALUES(TableName[Year]), TableName[Plan] = _plan ) RETURN CONCATENATEX( _year, TableName[Year], ", " )i tried and it worked like this:
FreemanZ
Super User
Super Userhi amit_msmba
what you want to return is a list/table, it is not good for a measure directly. what are you going to do with the needed "measure"?