Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Absalon29
Helper III
Helper III

Claculated column resulting blank values

I have two calculated columns in my report - years at company and years in industry. I can't work out why when I select both in a report one of the columns is returning blank values? When I remove one of the colums the blank disappear. 

Annotation 2019-06-24 135504.jpg

 

2 ACCEPTED SOLUTIONS
v-chuncz-msft
Community Support
Community Support

@Absalon29 

 

You may Use performance analyzer in Power BI Desktop to check query and take a look at Show items with no data.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

jdbuchanan71
Super User
Super User

Table visuals only displays rows where the measure returns data so if you only select the [Yrs in Industry] it will not show the blank rows.  When you add in [Yrs in Company] it has data in that measure for all those rows so it shows blank under [Yrs in Industry] where it has no data.

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

Table visuals only displays rows where the measure returns data so if you only select the [Yrs in Industry] it will not show the blank rows.  When you add in [Yrs in Company] it has data in that measure for all those rows so it shows blank under [Yrs in Industry] where it has no data.

v-chuncz-msft
Community Support
Community Support

@Absalon29 

 

You may Use performance analyzer in Power BI Desktop to check query and take a look at Show items with no data.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.