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,

 

>>If picked No then I am seeing wrong data that is 7 columns (Jul, Aug, Sep, Oct, Nov, Dec & Jan) (all with 0's or with data) but expected result is 6 columns with No Jan column displaying. But for me Jan data is displaying with 0's. 

I think you need modify your formula to add a condition to check selected column to replace unmatched records to blank.(default, if current column records show blank, matrix visual will auto hide this column)


Sample:

Measure =
IF (
    SELECTEDVALUE ( Table[Date] ) IN ALLSELECTED ( Table[Date] ),
    'Original measure formula',
    BLANK ()
)

 

BTW, can you please provide more contents help use clarity your scenario and expected result?

 

Regards,

Xiaoxin Sheng