cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
android1 Member
Member

What if?

 

This Measure returns the amount of wages paid to employees who have been employed >= the number of weeks selected in the Wks Employed slicer.

 

The second slicer, 'What if Wage increases by'  shows what the wages would be if they were increased by selected value.

 

What if Wages ? = CALCULATE([Pay Finalised] * [Wage Increase Value], FILTER(CarersList,[Wks of Employment _] >= 'Wks Employed'[Wks Employed Value]))

 

What I'm trying to show is the total What if Wages ?  if the selected What if Wage increases by is only applied to people who have been employed >= the number of Wks Employed slicer. So I need to show What if Wages ? regardless of how many weeks employed but only apply the increase to those employed >= 23 for example (in the pic below).

2018-08-12 08_25_36-Wages Invoiced WIP 2 - Power BI Desktop.png

1 REPLY 1
Super User
Super User

Re: What if?

Hi @android1

 

May be

 

What if Wages ? =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Wks Employed'[Wks Employed Value] )
        = SELECTEDVALUE ( CarersList[Wks of Employment _] ), CALCULATE (
        [Pay Finalised] * [Wage Increase Value],
        FILTER (
            CarersList,
            [Wks of Employment _] >= 'Wks Employed'[Wks Employed Value]
        )
    ),
    [Pay Finalised]
)

 

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 223 members 2,299 guests
Please welcome our newest community members: