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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nikhil_Rajana
Frequent Visitor

Getting blank values in calculated table when the measure is based on input parameter

Dashboard

Nikhil_Rajana_0-1689761244283.png

=======================================

The CAPEX measure is based on the parameters as shown in above image. When I am trying to create a calculated column in another table as shown in below image I am getting a blank value. My CAPEX measure is defined as follows: 

CAPEX = 'Plant capacity'[Plant capacity Value]*18600*1000
The 'Plant capacity'[Plant capacity Value] is a parameter that i am taking as user input.

Nikhil_Rajana_1-1689761287143.png

I dont understand why I am getting blank values. Please help!
@amitchandak 

@truptis 

5 REPLIES 5
Nikhil_Rajana
Frequent Visitor

Hi @baghdadi62 , i wish to fix the blank values. The year table you see in the below image is just a dimension table that I created by entering the data for my use case. I dont understand why the measure calculation is appearing blank in the calculated column "CAPEX" that I created.

Nikhil_Rajana_1-1689772900579.png

 

 

What is the [Plant capacity Value] formula?

Plant capacity = GENERATESERIES(0, 100, 0.5) - This is a parameter where I am taking user input
 

Just to add 

Plant capacity Value = SELECTEDVALUE('Plant capacity'[Plant capacity])
and 
CAPEX = 'Plant capacity'[Plant capacity Value]*18600*1000
baghdadi62
Resolver III
Resolver III

Hi. If I understand the question correctly, I should say that the calculation tables are not affected by the parameters of

the page.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.