Forum Discussion

armin_fan's avatar
armin_fan
New Member
4 years ago
Solved

DAX Constant Column is empty

Hello,

 

I encountered some weird behaviour in DAX. I have two table. One containing a column price with different prices called Arbeitspreis and one with only one column Verbrauch in kWh which consists of values between 0 and 30k with step size 1000.

 

 

Now the user can select a value from Verbrauch. Then I want a column to the price table which just multiplies each price with this value, but it always returns empty values. Here is my formula (quite simply actually):

 

 

 

2 Replies

    • armin_fan's avatar
      armin_fan
      New Member

      Hmm, I thought that a measure results only in one value, but I now use the matrix instead of the table with a measure and sumx and it works. Thanks.