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.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!