Forum Discussion
Calculated Column is returning blank values
MFelix and Anonymous
Found the soultion. I did all the calculation in SQL and then I am bringing my data to Power BI. It is working fine now.
Thanks alot for supporting guys.
You guys are great.
Thanks,
siddhant
It is kind of a temporary solution as I did nothing in Power Bi to resolve it. What I am doing is that instead of creating calculated fields in Power BI I am creating those column in my database itself while fetching the data.
Anonymous
th measure formula is simple. It has sales calculation based on current year.
Sales = CALCULATE(SUM(Table[Actual Sales]),FILTER(Table,Table[GL Fiscal Year] = MAX(Table[GL Fiscal Year])))
Since I don't see any of the column names mentioned in that measure in your sample table, I'll assume this all refers to a different table. That would mean that if you tried to run that measure in a column on this table, it would always return 0 because it has no row context to make that filter statement do anything. So you're always multiplying something by 0.
Anonymous,
No I have jsut 1 table. They all are part of same table. What I am showing in the sample table is the table vusal that I am trying to create from my data set. IThe measure and column are part of the same table.
Can you show a sample table that actually shows all the columns involved? Your sample table in your first post doesn't include any of the columns used by the measure so I can't tell how the measure is affecting the results. If all these columns are in this table we need to see all of them.