topic Re: Conditional with dynamic values in DAX Commands and Tips

Conditional with dynamic values

msam86 — Tue, 18 Jun 2024 12:54:55 GMT

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

Re: Conditional with dynamic values

Anonymous — Wed, 19 Jun 2024 02:18:25 GMT

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.

Re: Conditional with dynamic values

msam86 — Wed, 19 Jun 2024 13:57:36 GMT

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

Re: Conditional with dynamic values

Anonymous — Thu, 20 Jun 2024 01:36:30 GMT

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.

Re: Conditional with dynamic values

msam86 — Fri, 21 Jun 2024 18:46:44 GMT

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

test_sum.pbix

Re: Conditional with dynamic values

msam86 — Mon, 24 Jun 2024 19:05:01 GMT

Hello my friends,

Can anyone help?
Regards

Re: Conditional with dynamic values

Anonymous — Mon, 01 Jul 2024 09:33:05 GMT

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.