Forum Discussion

v-uprav's avatar
v-uprav
Frequent Visitor
8 years ago
Solved

Matrix data based on currentmonth in mapping condition.

I have a chicklet slicer which basically has Yes/No options which basically signifies selection of current month to be displayed or not. I have a matrix which has data coming from a table's measure a...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI v-uprav,

     

    You can try to use below formula, I added the condition to filter records when you choose 'No':

    Total =
IF (
    SELECTEDVALUE ( Records[Current Month] )
        IN ALLSELECTED ( 'Selector'[Current Month] ),
    SUM ( Records[Amount] ),
    IF ( SELECTEDVALUE ( Selector[Current Month] ) = "NO", BLANK (), 0 )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-uprav,

 

Maybe you can take a look at below sample if it suitable for your requirement:

 

 

Regards,

XIaoxin Sheng

v-uprav's avatar
v-uprav
Frequent Visitor
8 years ago

Hi v-shex-msft,

   This exactly matches with my requirement. So here when no is clicked we should not see Jan 2018 column itself (hide Jan 2018 column in the matrix) but here it is showing with zeros. I think you got my requirement. But here how to hide Jan 2018 column in the matrix if No is picked.

 

 

Thanks

Chary

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI v-uprav,

     

    You can try to use below formula, I added the condition to filter records when you choose 'No':

    Total =
IF (
    SELECTEDVALUE ( Records[Current Month] )
        IN ALLSELECTED ( 'Selector'[Current Month] ),
    SUM ( Records[Amount] ),
    IF ( SELECTEDVALUE ( Selector[Current Month] ) = "NO", BLANK (), 0 )
)

    Regards,

    Xiaoxin Sheng