Forum Discussion

pstanek's avatar
pstanek
Post Patron
10 years ago
Solved

Dax

Measure1  = Calculate( SUM(movement[pcena]); FILTER(movement; movement[date] >= NOW()-30 && movement[date] <= NOW())) Measure2  = Calculate( SUM(movement[pcena2]); FILTER(movement; movement[date...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    pstanek This should work for a Calculated Column in Table A

     

    Column = TableA[Pcena] * RELATED ( TableB[Parameter_n] )
Sean's avatar
Sean
Community Champion
10 years ago

pstanek Besides that . at the end of Measure3 there's nothing wrong with that formula

 

The difference between Measure1 and measure 1 - is the evaluation context - best way to explain/show is with a picture

Measure1 is the way to go even tough you get the same overall result in the bottom Total Row

 

Go to the Relationship View => select Column Office in either table => drag and point to column Office in the other table

The relationship will be established

 

Hope this helps. Le me know...

pstanek's avatar
pstanek
Post Patron
10 years ago

Measure 3 didn´t t work. Sometimes It writes something about function filter, that I can not be used in fuctions If and similar functions

 

I have already established relationship, but i don´t know How to create column in Table A .

Table a

Office1  goods1 Pcena1

Office1  goods2 Pcena2

Office2  goods1 Pcena3

 

Table B

Office_n parameter_n

Column should have values

Pcena*VLooklup(office_ n)

 

It means

Office1  goods1 Pcena1 Pcena1*VLooklup(office_ 1)

Office1  goods2 Pcena2 Pcena2*VLooklup(office_ 1)

Office2  goods1 Pcena3 Pcena3*VLooklup(office_ 2)

 

Vlookup will find parameterin Table B

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    pstanek This should work for a Calculated Column in Table A

     

    Column = TableA[Pcena] * RELATED ( TableB[Parameter_n] )