Forum Discussion
How would you approach this? Creating a reference for range of percentages
You want to assign each Item in Table 1 to a band based on price which is specified in Table 2. After assigned to a band, compare it to targe Gross Margin % target to determin if it meets goal. There are a lot of articles out there explaining how to implement banding. Here is one:
You want to assign each Item in Table 1 to a band based on price which is specified in Table 2. After assigned to a band, compare it to targe Gross Margin % target to determin if it meets goal. There are a lot of articles out there explaining how to implement banding. Here is one:
mattbrice Thank you so much for your response! I was successful in creating the banding!
I am having a problem with creating the categorization of either "Yes" or "No". Essentially, I am comparing a measure from one table against the Target Gross Margin % of another table (which is a disconnected table). The hope is to generate an output of either "Yes" or "No" from the comparison.
Below is my DAX measure but I am getting an error "A table of multiple values was supplied where a single value was expected". Not sure on how else to go about this because I have tried to rework the syntax a few ways but am still getting the same result.Any guidance will be greatly appreciated!
Target Gross Margin % =IF([Margin %_purch] >=FILTERS('Cost Gross Margin%'[Gross Margin]),"Yes", "No")