Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      v-xicai
      Community Support
      7 years ago

      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.