Forum Discussion
How to display the expected result
Hi Anonymous ,
Don't know if this is what you need but here is someting similar with a PBI exmple in attach.
If profit > 3.000.000 and country is France or Germany shows "Y" else shows "N".
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/
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".Anonymous i don't know the name of your columns but this should work, just replace the
table[Category] with the table and column from your category.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.