Sorry man. I was looking at wrong expression for the results. You are correct. For my knowledge, what was wrong with my if statement. For this scenario what would be the ideal solution ie. instead of writing a long expression. Is there any Set Analysis that will help or any data model change would require.
=if(Timestamp(FV_Date,'MM/DD/YYYY') =Max(Timestamp(FV_Date,'MM/DD/YYYY')) and Sub_Version = Max(Sub_Version), Dev_Count)
The reason why this can't work is that FV_Date and Sub_Version are not unambiguous per Make dimension value. You can see this when adding these as dimensions, there are lot of different values, so QV can't resolve above expression to one single answer.
You can slightly simplify my above suggested expression by removing the timestamp() formatting:
=aggr(if(FV_Date =max(total<Make,Sub_Version> FV_Date) and Sub_Version = Max(total<Make> Sub_Version), Dev_Count),Make, Sub_Version,FV_Date)
If you can extend your table in the data model by one more field:
Sub_Version + FV_Date/100000 as Test
you may be able to use FirstSortedValue() in your chart expression (if I understood your issue correctly), dramatically simplifying your expression to
