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.
Hi MFelix
Thanks for the reply but I tried using the IF condition and it is still showing me blank values for Target Sales.
Also I am having one more issue. I am creating another calculated column that tells current month target and i am using Target % column to do the calculation. When i am trying to create the column I am getting an error saying "A circular dependency was detected". Do you have nay suggestion on this one?
Thanks,
Siddhant
Hi siddhantk989,
Was looking at your information and made a trial and use this to eliminate the blanks:
Target Sales = SUMX(Sales; (Sales[Target %]+1)*Sales[Sales])
This is comparable to the SUMPRODUCT Function in Excel.
What's the formula you are using for the column?
Regards,
MFelix
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])))
- If.you change the sum(sales) for.your measure name.it.should work also.