image-2

How to Use HASONEVALUE to Remove Unexpected Sum

Review the table visual, noticing the total for the Target column. Summing the target values together doesn’t make sense because salespeople targets are set for each salesperson based on their sales region assignment(s). A target value should only be shown when a single salesperson is filtered. You will implement a measure now to do just that. Rename Read More