Forum Discussion

ruxandraalina's avatar
ruxandraalina
Icon for Helper I rankHelper 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
Icon for Impactful Individual rankImpactful Individual
4 years ago

HI,

 

Try this

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

    Hello, 

    Yess, this worked. Thank you very much!