The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
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/
Proud to be a 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:
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/
Proud to be a Super User!
I did it, your answer help me a lot.
Ty vry much for responding
What happens if i have filters and i want to stilll filtering by them?
I need to keep filtering by "cadena" and "upc", maybe for that reason my new measure is not loading in my table??