Forum Discussion

-VIP-'s avatar
-VIP-
New Member
4 years ago

Bar Chart With Filter To Calculation Values Differently

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.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    -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

  • -VIP-'s avatar
    -VIP-
    New Member
    4 years ago

    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.