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,

 

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