Forum Discussion

clauvera's avatar
clauvera
Regular Visitor
8 years ago

Put a value from a table visualization in a card visualization

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...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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's avatar
clauvera
Regular Visitor
8 years ago

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! :smileyhappy:

 

Regards

 

 

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

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

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        8 years ago

        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