Forum Discussion

msam86's avatar
msam86
Helper I
2 years ago
Solved

Conditional with dynamic values

Hello friends, how are you? With your help I was able to implement the status of one piece of equipment per year in a pie chart.   Now I wanted to implement another pie chart, where I can add up th...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi msam86 

     

    Try the following Measure:

     

    Measure 2 = 
VAR select_client = SELECTEDVALUE(Dados[Client])
RETURN
COUNTX(
    FILTER(ALL('Dados'),[Client]=select_client),[Client])

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi msam86 

 

All you need to do is put the fields from your existing table into the pie chart.

 

 

 

 

Best Regards,

Jayleny

 

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

  • msam86's avatar
    msam86
    Helper I
    2 years ago

    Hi Anonymous , I understand what you said, but I need another pie chart with customer information. For example, I need to see A = 33, B = 9, C=4....

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi msam86 

       

      Drag the column "equipment" into Legend.

       

       

       

       

       

       

       

       

      Best Regards,

      Jayleny

       

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

      • msam86's avatar
        msam86
        Helper I
        2 years ago

        Hi Anonymous . I shared my example. These numbers are provided by dynamic metric.

         

        test_sum.pbix