Assign Measure value to Column - for stack graph

[refint650]

Hello 

I'm using for stack bar chart  - one measure with multiple variables and filter conditions. 

how to match variable name to column name in chart.

Countx = count(product) 

Chart Measure  =

Var _Apple = calculate ([CountX], type ='Apples' and  Product = "Fruit" and Date =today()

Var_Raisins = Calculate([CountX], type ='Raisins' and  Product = "Other" and year(Date) =year(today())
Var_all = Calculate([CountX], year(Date) <=year(today())

-- i 'm doing of union all counts.

var _U1 = union(_Apple,_Raisins, All)

return 

addcolumns( _u1 , "apples", _Apple) ...?

[amitchandak · Accepted solution]

@refint650 , You can check if calculation group can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.