Forum Discussion

Arioli_Chezhian's avatar
Arioli_Chezhian
Icon for Helper II rankHelper II
2 years ago
Solved

TotalYTD performance based on Slicer filter

Hello everyone, I have a totalytd measure, and creating a bar chart based on date and total sales. Also I have a slicer which contains Month Name. If I filter for March month, the bar chart will sho...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Arioli_Chezhian 

     

    You can try the following methods.

    Measure = 
IF ( SELECTEDVALUE ( 'Slicer table'[Date] ) = BLANK (),
    1,
    IF ( SELECTEDVALUE ( 'Table'[Date] ) <= SELECTEDVALUE ( 'Slicer table'[Date] )
     && YEAR ( SELECTEDVALUE ( 'Table'[Date] ) ) = YEAR ( SELECTEDVALUE ( 'Slicer table'[Date] ) ),
        1,
        0 ) )

    Is this the result you expect? Please see the attached document.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Arioli_Chezhian TOTALYTD measure best work when you put Date columns from you Calendar / Date table, not from your fact table.

Arioli_Chezhian's avatar
Arioli_Chezhian
Icon for Helper II rankHelper II
2 years ago

some_bih  - I need to achieve the concept which I mentioned earlier. Could you please advice on this.