Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
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!
Here is the Model. They are one to many relationships between the IDs.
The only filter being applied is from an Excel sheet, which only includes people who are active with the Plan.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |