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

Zubair_Muhammad

 

It's perfect, i succeed to do whait i wanted with your help.

 

Thanks a lot for all.

 

Juste a small question for my personal understanding of the solution :

 

To detect if column "NAME" was filtered or not, i created a measure "IsFiltered" which whas :

IF(ISFILTERED[NAME]);"1";"0")

 

This formule was good because, when i display the measure in a card, it switched good between 1 and 0 when i filtered.

 

But when i write :

IF(ISFILTERED[NAME];SELECTEDVALUE[Y];SUM[X])

Thes formule doesn't work.

 

Any idea of why ?

 

Thanks