Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Put measure in every row

Hi everyone,

 

Im tryng to put a measure value in every row of my visual object table.

 

Gustavo98_1-1660961584510.png

This is my measure result, i want to have this value in every row to do some calculations.

Gustavo98_0-1660961532384.png

My last two columns has zeros because i have been trying to do that but without results.

 

I hope someone can help me.

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

If your measure works outside the table and you want to have it display the -0.69 on every row the problem becomes how you can maintain the same filter context as you had outside the table. To do this you can use functions such as REMOVEFILTERS, KEEPFILTERS and ALL. Here is an example:

ValtteriN_0-1660975214903.png

 


Measure 19 is just a SUM measure.
Measure 20 = CALCULATE([Measure 19],REMOVEFILTERS('Table (7)'))


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/








Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ValtteriN
Super User
Super User

Hi,

If your measure works outside the table and you want to have it display the -0.69 on every row the problem becomes how you can maintain the same filter context as you had outside the table. To do this you can use functions such as REMOVEFILTERS, KEEPFILTERS and ALL. Here is an example:

ValtteriN_0-1660975214903.png

 


Measure 19 is just a SUM measure.
Measure 20 = CALCULATE([Measure 19],REMOVEFILTERS('Table (7)'))


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/








Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

I did it, your answer help me a lot.

 

 

Anonymous
Not applicable

Ty vry much for responding

 

What happens if i have filters and i want to stilll filtering by them?

 

Gustavo98_0-1660999444947.png

I need to keep filtering by "cadena" and "upc", maybe for that reason my new measure is not loading in my table??

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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