I have an issue with this Power BI file. Unfortunatly, I cannot share the file with you. Just too much work to remove company data. But I have hope that you can give me somme ideas to resolve my problem.
As you can see by the image, everything works. My calculations are correct. But I only need the part in green. I do not want the orange part but when I remove any of the colums in the orange area then my CRL Volume Class Finale is wrong.
So all the columns need to be there to have the correct result.
What can I do ?
If it would be a database, I would create myself a materialized view (basically write (export) the results and then go back and just retrieve the 3 columns that i need. How can I do this in Power BI ?Data volume is not very big, so it would be OK to do this with Power BI.
I have 3 tables VLPC, NCA, CRL (desc in lower left of the image)
Volume Class Finale = CALCULATE(CRL[Sum Volume]) - CALCULATE(CRL[Volume Diff Jour Avant moins jour])
Basicaly, I’m calulating the SUM of Volume Minus the Volume Difference with the day before. (A little more complex but …)
How can I remove the 2 orange columns and still keep my correct results. (BTW, it’s been a lot of work for me to cet to this part, with all my correct values etc. So I’m close but not there yet)
Eric (Montreal, Canada)