- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculate Measure
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @DesireeMaya22,
Can you share some data and expected result so I can help you better.
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-25-2024 03:02 PM | |||
07-24-2024 12:31 AM | |||
07-25-2024 10:54 AM | |||
07-25-2024 08:07 AM | |||
08-12-2024 12:49 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |