Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
For reference, my model looks like this:
And more notes on measures created
Hi @PrivateAnalytic ,
According to your description, the problem is that after attaching other data to the visual, the original value has changed, and because there is no sample data, it is impossible to know the specific reason, but the example uses the DISTINCTCOUNT function, then this situation may be normal.
In different filtering contexts, the results obtained by the DISTINCTCOUNT function will also change, and it may be that the column you added changes the counting environment.
Getting the total value also needs to be analyzed according to the specific data, please upload the sample data to solve the problem faster.
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
75 | |
74 | |
49 | |
26 |