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] )
)

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
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

Zubair_Muhammad,

 

Thanks a lot for your help, i watched the file and it looks like exactly what i need.

 

I am going to try the measure you wrote on my real PowerBI report this afternoon.

I come back here if i have other questions.

 

Thanks a lot for the time you took to help beginners in the community !

 

Best,

SB