Forum Discussion
Calculate Measure
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
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.
Hi DesireeMaya22,
Can you share some data and expected result so I can help you better.
Regards,
MFelix
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!