Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 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? 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.