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

Can you tell new, which one is faster? Measure1 , or measure1

 

I have data, where Measure 1 is too slow. Results are not often calculated. I can even tell, I am at BI mercy, If results appear, or not.