topic Re: Need same information in DAX Commands and Tips

Need same information

by_tiago — Tue, 25 Jun 2024 14:49:14 GMT

Hello everyone! I’m in need of some help. Currently, I’m trying to create a card using the new visual in Power BI, the “New Card”. However, I’m facing a problem: the information displayed on the card is different from what is in the table.

For example, in the table, it shows that the MH-01 process is associated with IT. However, in the card visual, ED appears. From what I could perceive, the visual is taking the first piece of information and adding it to the card. However, I need the information on the card to be exactly the same as in the table.

Below is a screenshot to better illustrate the situation. I appreciate any help in advance!

Re: Need same information

amitchandak — Tue, 25 Jun 2024 15:10:01 GMT

by_tiago , if they are columns, a card will take the first value, unless there is a filter via another visual or slicer to give you the exact value. First card visual will not filter second one

Re: Need same information

Anonymous — Wed, 26 Jun 2024 06:31:48 GMT

Hi by_tiago

amitchandak Thank you very much for your prompt reply, please allow me to share some content here.

As the amitchandak says, the first card does not affect the second card.

They show the first value of each card.

In the "operador" column, the first value is "Ed" in alphabetical order.

Creating a slicer is a good way to do this. It dynamically displays the data you want to display.

If you just want to display the first data statically, you can choose to create a measure.

Measure Operador = CALCULATE( SELECTEDVALUE('Table'[operador]), FILTER( 'Table', 'Table'[processos] = "MH-01" ) )

Here is the result.

Regards,

Nono Chen

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