Forum Discussion
Put measure in every row
Hi everyone,
Im tryng to put a measure value in every row of my visual object table.
This is my measure result, i want to have this value in every row to do some calculations.
My last two columns has zeros because i have been trying to do that but without results.
I hope someone can help me.
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:
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/
3 Replies
- ValtteriN
Community Champion
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:
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/