Gauge with measure of specific value of the dimension

[#1]

Hi

I would like put one Gauge that it only show a measure of one dimension value p.e. X.

I have specified in the expresion of measure with an IF, but if there is only the X filter, it is ok, but if i don`t have filters o I have X and oter more, the Gauge don't show anything.

Thank you. Gabriel

[vinieme12]

Sorry Gabriel, couldn't understand the scenario or problem here.

Do you want your gauge to calculate only if particular values are selected??

Can you post your dimension expression , your calculation expression and screenshots to explain what you need, also confirm what field you are filtering on

[#3]

Hi Vineeth, thank you, I am going to try explain better. I will use one example

I have these data

DIM-A	DIM-B	MEA-A	MEA-B
X	M	1	6
X	M	2	6
X	M	3	4
Y	M	2	7
Y	M	5	8
Y	N	5	9
Z	N	4	0
Z	N	3	8
Z	N	4	4

I like have one independent gauge for each X, Y & Z DIM-A with the avg of MEA-A and always show the result independently if there are filters o select something.

I have proved with use function if in measure calculate, and I have also proved with put condition in data handling. But it doesn't work like I want.

I attached the example result

[vinieme12 · Accepted solution]

use the following expressions in your gauge

for DimA = X

     =AVG({<Dim-A=,Dim-A={'X'}>} MEA-A)

DimA = Y

    =AVG({<Dim-A=,Dim-A={'Y'}>} MEA-A)

DimA = Z

    =AVG({<Dim-A=,Dim-A={'Z'}>} MEA-A)

and Dimension  = Dim-A

[#5]

Thank you.

[#6]

Hi Vineeth .Similarly that.

If I need use a specific number (that I know calculate, it will be like a specific number value, more or less like a constant) into expression to calculate a measure.

How can I do?

Thank you.