Reply
dreambeforeyou
Frequent Visitor
Partially syndicated - Outbound

DAX Help needed - Whatif Parameter in Measure returning too many rows in child table

Here is a link to my code - https://drive.google.com/file/d/1-Ue0OVG2C-oPRK8GPKkgO0WwsW_8Z4mU/view?usp=share_link

 

dreambeforeyou_0-1675287624483.png

I have a Whatif slider, Adjusted Hours.  If a number is put into that slider, I want to create a dynamic value from the "Operation Hours" in my Packages table, using a measure.

 

Revised Hrs =

    IF('Adjusted Hrs'[Adjusted Hrs Value] = 0, SELECTEDVALUE(Packages[Operation Hours]),
        'Adjusted Hrs'[Adjusted Hrs Value])

 

But as soon as I put the Revised Hrs into my table, it returns all the Packages, instead of using the Filter from the selected Allocation (AllocationID=106)

 

dreambeforeyou_1-1675288019216.png

 

Please could you help, I've tried so many options?  Calculate, SUMX, trying to find how to do Rowlevel filtering.

 

I will then be doing the calculation/adjustment in each record of the the PackageDetail child table.

 

Thank you

Tracey

2 REPLIES 2
amitchandak
Super User
Super User

Syndicated - Outbound

@dreambeforeyou , Try like

 


Revised Hrs =

IF( not(isblank('Adjusted Hrs'[Adjusted Hrs Value])) && 'Adjusted Hrs'[Adjusted Hrs Value] = 0, SELECTEDVALUE(Packages[Operation Hours]),
'Adjusted Hrs'[Adjusted Hrs Value])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

Hi Amit,

Thanks so much for looking at my problem.  And yes, I so know I needed to fix the logic of the expression to check for both.  I really appreciate your help.

BUT, my actual issue is that when I use the Measure in my table, it ignores the filter of the Allocation ID and returns all rows.

So I want this, plus the [Revised Hrs]

dreambeforeyou_0-1675310840397.png

But instead when I add [Revised Hrs] to the table, I get this:

dreambeforeyou_1-1675310909005.png

How do I only return the 5 value for the single row?

Thanks again,
Tracey

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)