cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
abiyevnijat
Frequent Visitor

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

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.

question.png

1 ACCEPTED SOLUTION
abiyevnijat
Frequent Visitor

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.

View solution in original post

2 REPLIES 2
abiyevnijat
Frequent Visitor

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
Super User
Super User

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 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors