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,

 

 Sorry i didn't get it. can you pelsae tell me again what to do in it?

 

Thanks,

Siddhant

MFelix's avatar
MFelix
Super User
9 years ago
Recalculate your.measure using the sales mesuare.

Target Sales = SUMX(Table_Sales; (Sales[Target %]+1)*Sales)

In the first parameter use the table where you have your sales information.

Are the targets in the saless table or in another separate table?

Mfelix
  • siddhantk989's avatar
    siddhantk989
    Helper III
    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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi siddhantk989,

    Great job. Please mark your solution as workaround, so that more people will benefit from here.

    Thanks,
    Angelia

  • siddhantk989's avatar
    siddhantk989
    Helper III
    9 years ago

    MFelix I tried this but I am getting blank values in the Measure as well.

     

    Anonymous i can not shar the sample of the data set because i have around 92 attributes in my data set.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi siddhantk989,

    Glad to hear you have resoled your issue by yourself, please mark coresponding reply as answer. So that more people will benefit from it, and find workaround easily.

    Best Regards,
    Angelia

  • siddhantk989's avatar
    siddhantk989
    Helper III
    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.