Put a value from a table visualization in a card visualization

[clauvera]

Hi,

I'm new in the Power BI world, so I need your help, I have a table visualization, but I would like to extract a value from there and put it in a card visualization. 

For example: 

I have this table in my dashboard, but I want to display just "PMO" in a Card Visualization. 

And it must be interactive because I have filters in the dashboard. 

I hope to make myself understood, thank you very much.

Regards,

Claudia

[Ashish_Mathur]

Hi,

What result do you get when you use this measure

=FIRSTNONBLANK(Data[Gerencia Nacional],[HORAS T1])

or

=LASTNONBLANK(Data[Gerencia Nacional],[HORAS T1])

I have assumed that HORAS T1 is a measure

[clauvera]

Thanks, I haven´t use this because I don´t know the name of the column.  The table shown is a visualization, so it is not a table defined in data.

The solution to this is to create the table, but I dont want to because I need that this table  interact with the data segmentation included in the dashboard.

Hope you can help me! 

Regards

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[clauvera]

Hi,

you can download the PBI from this direction.

https://www.dropbox.com/sh/8alrnjx588em5fr/AAA10O4Qo22W19aENaN6XqFCa?dl=0

Thanks.

[Vvelarde]

@clauvera

Hi, try with this:

Medida2 =
VAR SummarizeTable =
    SUMMARIZE (
        BASE;
        BASE[GERENCIA NACIONAL BENEFICIARIA];
        "Horas"; SUM ( BASE[HORAS TI] )
    )
VAR Top1 =
    CALCULATE (
        VALUES ( BASE[GERENCIA NACIONAL BENEFICIARIA] );
        TOPN ( 1; SummarizeTable; [Horas]; DESC )
    )
RETURN
    Top1