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,...
Need Help
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

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