Forum Discussion

laurocarmo's avatar
laurocarmo
Frequent Visitor
2 years ago

Calculated columns based on filters

Dear all, I hope this post find you all health and safe!   I am new on Power BI, but I use Excel for many years. I am "converting" my Excel analysis to Power BI Desktop, but I found a dificul...
Need Help
laurocarmo's avatar
laurocarmo
Frequent Visitor
2 years ago

Hi ray_aramburo,

In fact, I was not able to create a formula / measure for this, because it retrieved only one answer.
One test I did is:

Medida = CALCULATE(SUM('Cálculo Ranking'[Qtde Serviços]);FILTER('Cálculo Ranking';'Cálculo Ranking'[Provedor]="ACESSOLINE TELECOMUNICACOES LTDA"))

but the result is not dinamic, but related only to one provider.
 
Other attempt was:
 
Coluna = 'Cálculo Ranking'[Qtde Falhas]/'Cálculo Ranking'[Qtde Serviços] IN SELECTEDVALUE(Table1[Ano];2020)

and this:
 
Coluna = AVERAGEX('Cálculo Ranking';('Cálculo Ranking'[Qtde Falhas]/'Cálculo Ranking'[Qtde Serviços]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, laurocarmo 

    Thanks for ray_aramburo reply. Would love to help, but you need to share out the logic that achieves the results you want and the pbix file without sensitive data for testing purposes.

    Best Regards,
    Yang
    Community Support Team

    • laurocarmo's avatar
      laurocarmo
      Frequent Visitor
      2 years ago

      Thanks ray_aramburo and Anonymous for the support,

      Sorry for my absence of knowledge, but could you tell me how to share these files?
      I've tried to attach them here, but I was not possible...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, laurocarmo 

        You can use Google Drive to share your pbix files as a link (you need to set it up to be accessible without an account login).

        Best Regards,
        Yang
        Community Support Team