I'm trying to get the total with the following conditions:
1. IsNet = True
2. SupplierCode = only selected code (say 1102 and 1103)
3. Specifically just for CompanyCode 6601, I would like to get the total even though IsNet is False (selected supplier code still applies)
Not sure what's the best approach. I tried to create custom column with IF statement creating True/False but, I can't get all the conditions.
This is what the data looks like:
Any help would be appreciated!!
Solved! Go to Solution.
Do you need a measure that gives you the total based on your conditions? IF so, which column should I sum?
For the SupplierCode, hope you will have a slicer in the report.
Yes, I need the sum of Total column based on the conditions.
As for slicer, does filter for suppliercode works as well? Or, does it have to be a slicer?
It looks like it works but I need to double check the result.
Also, want to double check the following. I need to create another measure where the condition is the opposite of the measure that you created. This time, I do not want to include company code 6601 and IsNet = false.
Does the following measure correct?
Table2[IsNET] = FALSE()
Table2[Company Code] <> 6601
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.