Calculated measure in the rows in Matrix visual

[poojithas]

Hi All,

I have a calculated measure which is calcaulted based on two other fields of a table.

I am trying to place the calculated measure in the rows of matrix visual, but I am unable to use the calculated field in the rows.

Could someone suggest if there is a way to use calculated measures in rows.

Thank you

[TomasAndersson]

Hi! 
Just to clarify, do you mean "calculated column" or "measure"? A measure can be values in a matrix but not rows. If it's a calculated columnd it should possible to use as rows in a matrix, but not values.

Great if you can share your data table, DAX, and visual you are trying to create.

[poojithas]

@TomasAndersson  : Yes, It is a calculated measure and trying to place this in the rows of the matrix visual.

Please find the screnshot below.

[TomasAndersson]

I see. I don't know how to make that possible with a measure. Is there any way to create a column with the same information and use that instead?

[poojithas]

I tried to use the a calculated col but I get a circular dependency issue.

[Anonymous]

Hi @poojithas ,

Measure and calcualted column are different. A calculated column returns static values, while a metric returns dynamic results. Measures can dynamically return results based on the context of rows in the visual.

So if you put the formula in the measure as it is in the calculation column, it may turn out to be wrong.

If possible, provide some simple sample data and expected results. I can try to create the calculated column based on your sample data. Pay attention to protecting data privacy.

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.