Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I want to create a line chart with multiple lines, here is the origin data
so the data should be transformed to this:
dim value_a value_b value_c
6-30 10 3 4
31-60 20 5 7
>60 2 9 23
I am new to use DAX, how can I create calculation or table use DAX to create these columns(dim, value a b c) and consider context with post_man, grade?
Thank you.
Solved! Go to Solution.
@Anonymous , create a common dimension with these values 6-30days, 31-60days, etc
Join with three columns dim_a, dim_b, dim_c , Two joins will be inactive and you can activate it using userelationship in a measure
example
calculate(count(Table[dim_b], userelationship(Table[Dim_b], dim[dim]) )
@Anonymous , create a common dimension with these values 6-30days, 31-60days, etc
Join with three columns dim_a, dim_b, dim_c , Two joins will be inactive and you can activate it using userelationship in a measure
example
calculate(count(Table[dim_b], userelationship(Table[Dim_b], dim[dim]) )
@amitchandak Thank you. Do you mean join three column is to build relationship between two tables? But it's unable to bulit relationship of 3 columns with another column.
If the relation is inactive, can it still calculation the real value with these3 calculation? as I use these calculations as value-axis and dimension table as the x-axis to make up a multiple line chart
Tried it, works well
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |