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.

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

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 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.

      • 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