Forum Discussion
Show hardcoded values for year 2020
Hi v-jingzhang and amitchandak, thanks for your time and the response. I have got the solution and now i can able to show those values in my chart.
Best Regards,
Srihari
amitchandak , I am using Distinctcount because, I want to select only one distinct value region and if it is one then I am trying to calculate the sum(value) for that particular region. Let's say forexample if i got Region as America then I am taking total sum(value) for America. Like that I have multiple regions in my region adjust table.
Hope this will give some clarity on this requirement
Best Regards,
Srihari
Hi Anonymous
It seems the issue is in the variable plug_year in measure VPY_Selected. Currently the result of plug_year is always blank because its if statement will never be true. To me, DISTINCTCOUNT('Region Selection'[Region]) and DISTINCTCOUNT('Segement Selection'[Segment]) are always greater than 1, so it doesn't calculate for 2020 values. Maybe you can first consider modifying the measure to meet the columns chart's requirement? It seems this chart doesn't need to consider Region and Segment?
Regards,
Community Support Team _ Jing
Hi v-jingzhang and amitchandak, thanks for your time and the response. I have got the solution and now i can able to show those values in my chart.
Best Regards,
Srihari