Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |