Forum Discussion
How to display the expected result
Hi Sérgio Silva,
I have gone through your attachement, it didn't work for me .
i need to provide all these item_typ = ("FG-1","FG-2","FG-3","04-FG","FG-05","FG-07","FG-08") and this "[Last 12 months v5-Sales]<>0".
1. If this "[Last 12 months v5-Sales]" is having value then it should be "Y".
2. If the item_type is anyone from above and if the "[Last 12 months v5-Sales]" value is blank for it then also it should display "Y".
Resolver VAnonymous i don't know the name of your columns but this should work, just replace the
Example:
Metric Name =
IF(
[Last 12 months v5-Sales] <> 0,
"Y",
IF(
ISBLANK([Last 12 months v5-Sales]) &&
SELECTEDVALUE(table[Category]) ="FG" ||
SELECTEDVALUE(table[Category]) = "FGS" ||
SELECTEDVALUE(table[Category]) = "FGD-SKU" ||
SELECTEDVALUE(table[Category]) = "04-FG" ||
SELECTEDVALUE(table[Category]) = "FG-PARENT" ||
SELECTEDVALUE(table[Category]) = "TANDEM FG" ||
SELECTEDVALUE(table[Category]) = "FG-FG",
"Y",
"N"
)
)
Hi Sérgio Silva,
I have tried the measure provided by you, its not displaying values as expected.
When i remove a page level filter that is applied, the values are coming as expected. I tried to provide "ALL(country[country name])" in the measure, to restrict that page level filter column. But it didn't work.
- SergioSilvaPT
Anonymous Is it possible to share the dataset with the problem so i can check?