cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: Calculated Column is returning blank values

@KHorseman,

 

 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.

Highlighted
Super User I
Super User I

Re: Calculated Column is returning blank values

Can you show a sample table that actually shows all the columns involved? Your sample table in your first post doesn't include any of the columns used by the measure so I can't tell how the measure is affecting the results. If all these columns are in this table we need to see all of them.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User III
Super User III

Re: Calculated Column is returning blank values

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper III
Helper III

Re: Calculated Column is returning blank values

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

 

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

Highlighted
Helper III
Helper III

Re: Calculated Column is returning blank values

@MFelix and @KHorseman 

 

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

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Calculated Column is returning blank values

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

Highlighted
Helper III
Helper III

Re: Calculated Column is returning blank values

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

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Calculated Column is returning blank values

Hi @siddhantk989,

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

Thanks,
Angelia

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors