Forum Discussion
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):
armin_fan , You can not use slicer values in a new column. You can use that in a measure only
2 Replies
- amitchandakSuper User
armin_fan , You can not use slicer values in a new column. You can use that in a measure only
- armin_fanNew 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.