Forum Discussion

ruxandraalina's avatar
ruxandraalina
Helper I
4 years ago
Solved

Exclude value from rows, but include in total

Hello! I've been struggling with a Power BI issue and hopefully someone could help here 🙂    I have some SLAs that are calculated per group category (highest hierarchy level), region, team and op...
Need Help
  • PVO3's avatar
    PVO3
    4 years ago

    HI,

     

    Try this

    IF(
        SELECTEDVALUE('Table'[Operator group]) IN {"A","B"}, BLANK(),
        [Measure])
    )
PVO3's avatar
PVO3
Impactful Individual
4 years ago

HI,

 

Try this

IF(
    SELECTEDVALUE('Table'[Operator group]) IN {"A","B"}, BLANK(),
    [Measure])
)
ruxandraalina's avatar
ruxandraalina
Helper I
4 years ago

Hello, 

Yess, this worked. Thank you very much!