Issues with Finding a Value

[Anonymous]

Hello all! I am very perplexed on a particular value for a report I am creating. So I created a visual which shows the amont of people who are doing a particular task of a site (1st Picture). For this visual, I am using a column from the data I got, as well as a measure I created which calculates the distinct count of users. Now, when I look to add the subtasks as a legend to the report, using the same other 2 values, it is showing an increase in values by 20. I am very perplexed on how there is a 20 point jump just by simply adding the subtask as a legend to the visual. I would also like to figure out how to grab the total value from the 2 visuals. I am just so confused on this. Is there a DAX formula I can use for it? 

[Mikelytics]

Hi @Anonymous 

It is really hard to say based on your input. Is there a m:n or 1:n logic between your site and legend?

For being able to help you Can you please provide the following?

• Picture of the data model where I see relevant tables, columns and relations
• Formula definitions for the measures which are currently used your visual
• Description of filter which are applied on the visual

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Anonymous]

Hello Mike! Certainly!

• Picture of the data model where I see relevant tables, columns and relations

Here is the Model. They are one to many relationships between the IDs.

• Formula definitions for the measures which are currently used your visual

1. For the count of Purchase Plan Adopters = DISTINCTCOUNT('Users & Event-Ryan'[id])

2. The Client Plan Progression Table is formulated like:

Client Plan Progression =

SUMMARIZE('Users & Event-Ryan', 'Users & Event-Ryan'[id],

"PPP Task Completions", CALCULATE(COUNT('Users & Event-Ryan'[Task Completion Flag])))

• Description of filter which are applied on the visual

The only filter being applied is from an Excel sheet, which only includes people who are active with the Plan.