Bar Chart With Filter To Calculation Values Differently

[-VIP-]

Hi,

I have machine utilization data with follwoing columns:

ID, Date, Category, Idle Hrs, Work Hrs, Total Hrs, Expected Hrs, Productive Hrs, Non Productive Hrs, Hrly Rate, Total Cost

I want to create a bar chart to show Category on X axis and Total Cost on Y axis.

I then want to create a filter so user can select how to calculate Total Cost - wether it is based on Work Hrs or Total Hrs column.

If Work Hrs is selected then:

Non Productive Hrs = Expected Hrs - Work Hrs

Total Cost = Non Productive Hrs x Hrly Rate

If Total Hrs is selected then:

Non Productive Hrs = Expected Hrs - Total Hrs

Total Cost = Non Productive Hrs x Hrly Rate

If someone could guide on how to do this, it would be a great help!

Thank you.

[-VIP-]

Thank you @amitchandak for your suggestion.

I shall give this a try and see how it goes..! One other question though, how would the new measure impact the performance? Considering the table may have approx 1million rows?

Thanks again.

[amitchandak]

@-VIP- Create a table with those two values Work Hrs and Total Hrs and use as slicer

then create a measure

Switch(selectedvalue(Slicer[Value]) ,

"Work Hours" , Sum([Expected Hrs]) - Sum([Work Hrs]) ,

"TotalHours" , Sum([Expected Hrs]) - Sum([Total Hrs])

)

Like an old measure slicer technique

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M