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.
I was using the general calculation without using any formula.
Target Sales = (Sales[Target %]+1)* [Sales]
I am trying to implement the new solution using SUMX and I am getting a circular dependency error in it.
Just to inform you Sales is not a column it is measure that i have created based on conditions.
Thanks,
Siddhant
It would probably help to know what that measure formula is. Hard to tell why a formula is failing if we can only see half of it.
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.