Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to display the expected result

Hi All Experts, I have an issue with my measure, i am not able to get expected results. measure 1 var v1 = IF( FIRSTNONBLANK('Item'[ITEM_TYPE], 'Item'[ITEM_TYPE]) IN {"FG-1","FG-2","FG-3","04-FG...
Need Help
SergioSilvaPT's avatar
SergioSilvaPT
Icon for Resolver V rankResolver V
3 years ago

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/

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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".