Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
PrivateAnalytic
Helper IV
Helper IV

I am perplexed on my Report Values and how to get them

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? 

PrivateAnalytic_0-1669666924979.png

PrivateAnalytic_1-1669667012231.png

For reference, my model looks like this:

PrivateAnalytic_0-1669723505401.png

And more notes on measures created 

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])))
1 REPLY 1
v-jialluo-msft
Community Support
Community Support

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.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors