Show hardcoded values for year 2020

[amitchandak]

@Anonymous , I check file. Based on Intial idea.

You need measure like

if(Max('Week-month'[year]) = 2020 , [mesure from region adjust], [Other measure])

Also, check this visual might suite you need better - https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000675?tab=overview

[Anonymous]

Hi @amitchandak,

Thanks for the response. But I have tried that solution but no luck. Below is the measure that I am trying to modify

Best Regards,

Sri

[amitchandak]

@Anonymous , I think you have to use If only on week month year for value 2020 to shift measure? why you have used DISTINCTCOUNT('Segement Selection'[Segment])=1 and DISTINCTCOUNT('Region Selection'[Region])=1 ?

[Anonymous]

@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

[v-jingzhang]

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

[Anonymous · Accepted solution]

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