Forum Discussion
Calculating performance vs. target; 'left to get' versus target; performance growth in % terms
v-frfei-msftHi. I am working with the dummy file / your pbix, and moving info back in to my working model as I work through the components and understand them.
When I bring in the 'Left to Get' calculated measure (which you helped me to create) to a table on my visualizations panel, it has the strange effect of calculating left to get for roles / reps that have been filtered out using page level filters. This forces the table to dramatically expand and include people / roles that were filtered out prior to adding in the calculated measure.
I can see that the page level filters have been applied to the visual level filters, but the unwanted info still shows in the table.
Is there any way to prevent this from happening?
Hi Anonymous ,
Did you create correct relationships between tables? And did you add the same columns as my pbix to the visual?
Regards,
Frank