Forum Discussion

abiyevnijat's avatar
abiyevnijat
Frequent Visitor
2 years ago
Solved

PowerBI dynamic columns based on slicer

Hello everyone,   Business Time % = IF ( 'Dashboard'[Business] < [SLA Time], 1, [SLA Time] / 'Dashboard'[Business] )   I have calculated column in my main table (Dashboard). My SLA Time measure...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi abiyevnijat ,

     

    For this you need to use a different measure. Try the following measure:

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

     

     

     

    See PBIX file attach.

     

     

     

     

  • abiyevnijat's avatar
    abiyevnijat
    Frequent Visitor
    2 years ago

    Thanks for quick response. I visited this link, but I cant get suitable information for my problems. I create parameter table and added to slicer,but I cant get wanted result. All rows in my column display null when I change slicer.