topic Re: How to reference dimension value in measure calculation in App Development

How to reference dimension value in measure calculation

Bharath080 — Thu, 05 Oct 2023 19:20:03 GMT

How to reference dimension value in measure calculation,

In pivot table I have measures for which dimension have to be different for different measures, hence I created a static dimension now I need these measures to be linked to value in dimension, hence I need to know how to reference dimension in measure calculation

Re: How to reference dimension value in measure calculation

rwunderlich — Fri, 06 Oct 2023 08:38:23 GMT

Reference the Dimension by fieldname, eg

if(Region='EMEA', ...

-Rob

Re: How to reference dimension value in measure calculation

Bharath080 — Fri, 06 Oct 2023 11:03:57 GMT

There are 250 value in that field hence it has to be dynamic