DAX calculation or table with context

[Anonymous]

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.

[amitchandak · Accepted 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]) )

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

[Anonymous]

@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

[Anonymous]

Tried it, works well