Unable to add Calculated Measures under Rows in Matrix Table

[harirao]

Hi All,

Can you please assist me on the below, I have created calculated measures, but unable to include same under Rows in Matrix table

Need to created visualization as per below snapshot

Thanks for your help

Regards,

[v-rzhou-msft · Accepted solution]

Hi @harirao 

I think you want to show column header "No.of Deals", ">6 weeks visibility"... to show in Rows like the screenshot you show.

Now your visual shows like mine as below.

You can try "Show on rows" option in value in format.

Best Regards,

Rico Zhou

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

[Pragati11]

Hi @harirao ,

Are you trying to move a calculated MEASURE to the "Rows" section under Matrix visual?

If yes, then it won't work because measure gives you a single value.

"Rows" section accepts only COLUMN fields with multiple values. So, you may need to convert your MEASURE calculation to a COLUMN caluclation if you want to use it.

Thanks,

Pragati