Forum Discussion

RatanBhushan_05's avatar
RatanBhushan_05
Icon for Helper I rankHelper I
3 years ago
Solved

How to ignore slicers from same table while creating mesaure?

https://www.dropbox.com/scl/fi/r1e4bnsf3d6xz6icxxi2i/TestFile.pbix?rlkey=8q62cq8arlz976ysuz3q4xcov&dl=0  Hi Team   I am trying to create 3 meaures -  Measure 1 in which user can see sum of values...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, RatanBhushan_05 

     

    You can try the following methods to create a new date table.

    Date = VALUES(Sheet1[Month_Modified_2])

    Measure 1 = SUM(Sheet1[Value])
    Measure 2 = 
CALCULATE ( SUM ( Sheet1[Value] ),
    FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Attribute] ),
        [Month_Modified_2] = SELECTEDVALUE ( 'Date'[Month_Modified_2] )
    )
)
    Difference = [Measure 2]-[Measure 1]

    Is this the result you expect?

     

    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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, RatanBhushan_05 

 

You can try the following methods to create a new date table.

Date = VALUES(Sheet1[Month_Modified_2])

Measure 1 = SUM(Sheet1[Value])
Measure 2 = 
CALCULATE ( SUM ( Sheet1[Value] ),
    FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Attribute] ),
        [Month_Modified_2] = SELECTEDVALUE ( 'Date'[Month_Modified_2] )
    )
)
Difference = [Measure 2]-[Measure 1]

Is this the result you expect?

 

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.