combine measure and column into one measure

[Anonymous]

Dear Comuunity, 

I have a matrix which I want to show in each cell,combination of  below measure and a column which comes from another table from database, 
how can I do this?  cause is it not possible to combine a measure and a column from database into one measure, what should I do? 

I want each cell in matrix like below. 
for example:  37.5 , 0.5
37.5 is amount ot measureAvgY and 0.5 is comes from column.


MeasureAvgY = ROUND(

IF(

ISINSCOPE('M'[D]),

SUM('M'[Y]),

CALCULATE(

CALCULATE(AVERAGE('M'[Y]), FILTER('M', 'M'[IO] == 0)),

ALLEXCEPT('S','S'[C],'S'[S], 'S'[L])

)

), 1)

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try this measure

Measure = [MeasureAvgY]&","&SUM('Table'[Column])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Measure and column can combine in a measure

[measure] + sum(Table[Column]) // It can be min/max, avg/count etc