Conditional with dynamic values

[msam86]

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 the equipment, regardless of the status. With the 2 graphs I can see the associated information.

Ex: 2024

Ex: 2025

I inserted a spreadsheet to demonstrate what I need in the pie chart. The number of equipment will not change, but I need this relationship between the graphs to view the information

Ex: 2024

When I switch to 2025:

Can any friend help me?

Regards

[msam86]

Hello my friends,

Can anyone help? 
Regards

[v-jialongy-msft · Accepted solution]

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.

[v-jialongy-msft]

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]

Hi @v-jialongy-msft , 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

[v-jialongy-msft]

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]

Hi @v-jialongy-msft . I shared my example. These numbers are provided by dynamic metric.

test_sum.pbix