Reply
DesireeMaya22
New Member

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?

5 REPLIES 5
Ashish_Mathur
Super User
Super User

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/
MFelix
Super User
Super User

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



@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. 

 

Captura.PNG

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



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!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)