Forum Discussion
Dinamic rows using tabela
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 c...
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.
Hi Anonymous ,
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.