Stacked Column Chart with Legend. Data Labels on appearing as total

Question

Really struggling with some DAX&nbsp;Basically I have a fact table and dimensions.&nbsp;In the fact table I have a Person ID (Business Key. It can be repeated in slices of data. for example it can be in multiple times a month. And it will probably be in every months snapshotted dataset. So I have a DISTINCTCOUNT(PersonID) which will give me the total number of people when I slice it.&nbsp;So I have Area in a dimension.take this example of one&nbsp; of the areasThis is showed using the Total People Measure above&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SnapshotDatesArea&nbsp; &nbsp; 01/01/23&nbsp; &nbsp; &nbsp; &nbsp;01/02/223&nbsp; &nbsp; 01/03/23&nbsp; &nbsp; &nbsp; &nbsp;01/04/23&nbsp; &nbsp; &nbsp;01/05/23&nbsp; &nbsp; &nbsp; &nbsp;01/06/23&nbsp; 01/07/23&nbsp; 01/08/23&nbsp; &nbsp;TOTALA&nbsp; &nbsp; &nbsp; &nbsp;210&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 215&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 236&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 261&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;228&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;231&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 258&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;335&nbsp; &nbsp;&nbsp;&nbsp;the issue here is that there are 335 unique Person IDs but this is snapshot data so these people can be in every snapshot. So the total isnt adding up to all the values. This is ok here. I can just turn the total off.&nbsp;If I do the average in Excel I get&nbsp;&nbsp;235.7777778However I created this Measure&nbsp;&nbsp;Average No of Pupils = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AVERAGEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('Dim Date '[Snapshot]),DISTINCTCOUNT('Fact'[PersonID])))And all it does when I use it in a Bar chart is show me the total of Unique Pupil IDs 335&nbsp;So at present I dont know how to show the average because of this data set Im working with. If anyone has an idea. I would be grateful&nbsp;

lbendlin · Answer

I don't think you need the VALUES part.
&nbsp;
Please provide sample data that fully covers your issue.Please show the expected outcome based on the sample data you provided.

Forum Discussion

Stacked Column Chart with Legend. Data Labels on appearing as total

1 Reply

Related content

Stacked Column Chart Displays Incorrect Total Values After Adding Legend

Report not appearing in app

stacked column chart legend order

Stacked column chart with dynamic legend

Using a Measure as a Legend in a Stacked Column Visual