Forum Discussion

mike_s's avatar
mike_s
Regular Visitor
8 years ago

Values in chart all the same

Hi,   Hoping someone can help as my knowledge is pretty basic at the moment. Basically i'm trying to determine number of incidents by location or by status, for example.   The table i need to get...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mike_s,

From the screenshot, the “Count of id” is in Value bucket. I would like to know if the “Count of id” means the id column set with Count aggregation, or it’s a measure name. If it’s the former, please share corresponding id values for each value_caption. If it’s the later, please share the DAX of this measure.

 

To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

 

Regards,

Daniel He

mike_s's avatar
mike_s
Regular Visitor
8 years ago

Hi v-danhe-msft,

 

"Count of ID" is set with count - i havent created a measure that i am aware of- see screenshot below. I also wanted to point out that if i query values in other tables it counts ID quantity fine. It's just from this one particular table (In which "list_name" is) where i need to reference multiple entries within the same column (location, status etc):

 

 

does that help?

 

Thanks