Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
Solved

Calculated Column is returning blank values

Hi,     I am trying to create a table to show my forecast data. the forecast data is based on category and i have Target % to calcualte the forecast. Sales column is a measure which i am calulating...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • siddhantk989's avatar
    siddhantk989
    9 years ago

    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

  • siddhantk989's avatar
    siddhantk989
    9 years ago

    v-huizhn-msft,

     

      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.

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

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

 

MFelix's avatar
MFelix
Super User
9 years ago
If.you change the sum(sales) for.your measure name.it.should work also.