PowerBI dynamic columns based on slicer. NEED HELP!!!

[abiyevnijat]

Hello everyone,

I have calculated column in my main table (Dashboard) like that:
Business Time % = IF ( 'Dashboard'[Business] < [SLA Time], 1, [SLA Time] / 'Dashboard'[Business] )

then created measure like that:
AVG Business Time % = AVERAGE('Dashboard'[Business Time %])

Format of Business column is decimal number and it represent hour of completed tasks. Every row of column is different from 0 to 100.
My SLA Time measure is SLA Time = 2
which is not dynamic and I am changing manually. I want to create slicer dropdown visual which values changing from 1 to 48 instead of SLA Time. When I select my wanted value from slicer I want to get result AVG of Business Time % dynamically.

I got this result manually, but I want to share this in web. That is why want to get result dynamically for users.

[abiyevnijat · Accepted solution]

Business Time % =
VAR temptable =
    ADDCOLUMNS (
        'Dashboard',
        "@BusinessTime%",
            IF (
                'Dashboard'[Business] < SELECTEDVALUE ( 'Slicer'[Slicer] ),
                1,
                SELECTEDVALUE ( Slicer[Slicer] ) / 'Dashboard'[Business]
            )
    )
RETURN
    AVERAGEX ( temptable, [@BusinessTime%] )

This is final solution of my task.

[Idrissshatila]

Hello @abiyevnijat ,

check this https://youtu.be/6a_5uderwAg?si=WgU4Leb3uEVHPRD2

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡