Forum Discussion

SebKaliVith's avatar
SebKaliVith
Regular Visitor
8 years ago
Solved

IF column filtered then

Hi everyone !   Here is how the data look like in my report :   NAME     X       Y      Z    A         3%   10%     B         1%   7%    A         5%   6%    B         1%   11%     C        ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi SebKaliVith

     

    See the revised file here

     

    I just changed selectedvalue to sum

     

    Measure =
IF (
    COUNTROWS ( ALLSELECTED ( TableName[NAME] ) )
        = COUNTROWS ( ALL ( TableName[NAME] ) ),
    SUM ( TableName[x] ),
    SUM ( TableName[y] )
)

SebKaliVith's avatar
SebKaliVith
Regular Visitor
8 years ago

HI Zubair,

 

Thanks a lot for your help !

 

I tried yesterday evening the solution of your first post, but unfortunately it didn't work.

I look the file you sent me and i reply here.

 

Thanks a lot for your help