Forum Discussion
Issues with Finding a Value
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 thi...
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.
-----------------------------------------------------
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.