Forum Discussion

CSpina's avatar
CSpina
Helper III
6 years ago
Solved

How do I get value form column x row

My be a silly question, but is my mind

 

How do I get a value from column and row?

 

 
I have tried using a measure below:
 
Measure = 
CALCULATE(SUM(fEMPL_AUT[Valor]),FILTER(fEMPL_AUT,fEMPL_AUT[Linha]=1975&& fEMPL_AUT[Coluna] = 1975))
 
Thanks in advance.
 
Need Help

11 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    CSpina , In this case, you need two-year dimension.  Or can work with two-column in the table.

     

    one on row ,fEMPL_AUT[Linha] and one on column  fEMPL_AUT[Coluna]

    with measure

    CALCULATE(SUM(fEMPL_AUT[Valor])))

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi CSpina ,

     

    can you provide sample data?
    With date columns you can try the following.

    Measure = 
CALCULATE(SUM(fEMPL_AUT[Valor]),FILTER(fEMPL_AUT,fEMPL_AUT[Linha].[Year]=1975&& fEMPL_AUT[Coluna].[Year] = 1975))

     

    • CSpina's avatar
      CSpina
      Helper III
      6 years ago
      ANO1970197119721973197419751976
      1970320.670318.265311.852303.033299.025295.177293.413
      1971 412.121409.030400.788389.454384.303379.357
      1972  474.343470.785461.299448.254442.325
      1973   571.193566.909555.485539.777
      1974    655.140650.226637.124
      1975     674.633669.573
      1976      705.136

       

      I want to get  ANO 1970 column 1976

      • CSpina's avatar
        CSpina
        Helper III
        6 years ago
        ANO1970197119721973197419751976
        1970320.670318.265311.852303.033299.025295.177293.413
        1971 412.121409.030400.788389.454384.303379.357
        1972  474.343470.785461.299448.254442.325
        1973   571.193566.909555.485539.777
        1974    655.140650.226637.124
        1975     674.633669.573
        1976      705.136
    • CSpina's avatar
      CSpina
      Helper III
      6 years ago

      LINHA;1970;1971;1972;1973;1974;1975;1976;1977;1978;1979;1980
      1970;320670;318264,975;311851,575;303033,15;299024,775;295176,735;293413,05;286999,65;280586,25;274653,855;269205,402
      1971;;412121;409030,0925;400787,6725;389454,345;384302,8325;379357,3805;377090,715;368848,295;360605,875;352981,6365
      1972;;;474343;470785,4275;461298,5675;448254,135;442324,8475;436632,7315;434023,845;424536,985;415050,125
      1973;;;;571193;566909,0525;555485,1925;539777,385;532637,4725;525783,1565;522641,595;511217,735
      1974;;;;;655140;650226,45;637123,65;619107,3;610918,05;603056,37;599453,1
      1975;;;;;;674633;669573,2525;656080,5925;637528,185;629095,2725;620999,6765
      1976;;;;;;;705136;699847,48;685744,76;666353,52;657539,32
      1977;;;;;;;;682288;677170,84;663525,08;644762,16
      1978;;;;;;;;;802004;795988,97;779948,89
      1979;;;;;;;;;;832669;826423,9825
      1980;;;;;;;;;;;797395

      • CSpina's avatar
        CSpina
        Helper III
        6 years ago

        In fact, I have to calculate the total of yellow cells, it´s blowing my mind.