Forum Discussion

rosefei's avatar
rosefei
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

formula sum vs table sum

Hi all,   I have a rating table that have the following columns: 1) service 2) categoryID 3) subcategoryID 4) rating 5) target 6) BelowTarget = IF(rating<target, "Yes", "No) 7) BelowTargetDe...
Chthonian's avatar
Chthonian
Icon for Helper III rankHelper III
6 years ago

Hi rosefei ,

 

Looking at your description and your DAX, you seem to be using a measure that you have not defined "[TargetProfile]" - what is this calculation?

rosefei's avatar
rosefei
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Target = TargetProfile. Sorry I typed the table and did not type the name right