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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.