Forum Discussion

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago
Solved

Ignore the Month filter for one visual

Hi Team,   I have Year and Month filters  in my report from Date Dimension. And i have simple table chart showing "Compare From" and "Compare To" measures along the month. Relationship is setup be...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi ncbshiva ,

     

    One sample for your reference. Please check the following steps as below.

     

    1. Insert an index column in power query.

    2. To create a calculated table as below.

     

    Table = SELECTCOLUMNS(Table1,"month",'Table1'[Month],"Monthno",Table1[Index])

    3. Then we can achieve our goal by this measure.

    new compare from = 
VAR mon =
    SELECTEDVALUE ( 'Table'[Monthno] )
RETURN
    CALCULATE (
        SUM ( Table1[Compare From] ),
        FILTER ( 'Table1', Table1[Index] <= mon )
    )

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ncbshiva ,

 

One sample for your reference. Please check the following steps as below.

 

1. Insert an index column in power query.

2. To create a calculated table as below.

 

Table = SELECTCOLUMNS(Table1,"month",'Table1'[Month],"Monthno",Table1[Index])

3. Then we can achieve our goal by this measure.

new compare from = 
VAR mon =
    SELECTEDVALUE ( 'Table'[Monthno] )
RETURN
    CALCULATE (
        SUM ( Table1[Compare From] ),
        FILTER ( 'Table1', Table1[Index] <= mon )
    )