Dinamic rows using tabela

[veronicarocha]

I’m using the table bellow as dinamics rates for the year.

And my BI chooses what row it should use, depending on  the vessel (Sonda) and year(Ano).

I would like to know, is how can I create a way to choose the rows UNP, when I select the years (ANO) 2018 or 2019 and the slicer Year (ANO) with the option every (All options filtered) ?

[v-xicai]

Hi @veronicarocha ,

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

Best Regards,

Amy

[veronicarocha]

Below is the link with the files,

https://drive.google.com/drive/folders/1x7ynFAD582b-CW1h3TPFJHF2sDrrGR1d?usp=sharing

I would like to use a specifc value on my chart, when my slice is set with every and a year, as bellow.

In the imagem above, is being shown 19.5 that is sum of values contained in the year of 2018, In this case, i would like to show 1.9 instead.

[v-xicai]

Hi @veronicarocha ,

You may create measure like DAX below.

Measure1 = CALCULATE(MAX(Metas[TFSA]),FILTER(ALLSELECTED(Metas),Metas[SONDA]="UNP"))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.