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...
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