Calculate Measure

[DesireeMaya22]

Hi

I tried made a function with a filtren that you can choise in the report (a visual filter)

X = calculATE(countrows(Circuitos),Circuitos[MAPA DESTINO]=[Base Ajustada Origen])

Measure = Base Ajustada Origen, the value that it generate is "HID"

But it not recognize the mearsure like a text. The messeage said that i can´t used a mesure with a dinamic visual.

could you help me?

[Ashish_Mathur]

Hi,

Sincce you are comparing a column to a measure, you should use the FILTER() function.

=calculATE(countrows(Circuitos),FILTER(Circuitos,Circuitos[MAPA DESTINO]=[Base Ajustada Origen]))

Hope this helps.

[MFelix]

Hi @DesireeMaya22,

Not really sure if I understand wht you want to achieve but when you create the measureis it based on a column or something?

To use a filter on a report like a slicer or something like that you need to use a column. The use of measure implies a context and based on that the calculation is made, that's why you can't use it in as a dinamic visual since it's a calculation not a way to filter out information on a visual.

Please share some sample data and expected result.

Regards,

MFelix

[DesireeMaya22]

@MFelix

Thanks for your answer, the issue is that I would like to use a visual filter to calculate a measure. my dashboard refers about logistics so i have to chose a departure and then the first arrive and then the first arrive become into the departure and then you have to choise an other arrive, for this reason I take a measure to mention the first arrive to use it in the second calculation. 

I dont think about an other way to made it, even if a try to use function "IF" it doesn´t work. 

[MFelix]

Hi @DesireeMaya22,

Can you share some data and expected result so I can help you better.

Regards,

MFelix

[DesireeMaya22]

Hi @MFelix

Here is the example in excel: 

https://www.dropbox.com/s/t85pfgko49hy6a2/Ejemplo%20de%20An%C3%A1lisis.xlsx?dl=0

As you can see, the cell in green shows the visual filter that i put into the dashboard, the thing that i tried to do is take 2th arrive ("HID") to use it as the new departure and use it into the blue line for the netx measure. So that why I make a measure to mention the selection in filter visual to create an other measure. 

Thanks you so much!