Measure is not working with slicer

[canddig]

Hi, 

I created a few measures that will be used on cards to display different metrics. When I use my slicers my measurements are not all updating. Only parts of them are which is then throwing off my calculations. Can anyone help me with as to why when I select a slicer this would not update the measure correctly? It is not date related. Is there anything I need to add to my formula to take the slicer into consideration? 

Thanks, 

Candace 

[Anonymous]

Hi @canddig ,

Can you share some sample data and the expected result to have a clear understanding of your question? (screenshots as well)

In addition, the formula you gave seems to be simplified.

Filtered Amount - Net Rev =
'2020 Financials Budget Detail (2)'[Filtered Amount - Gross Rev]
+ CALCULATE (
SUM ( '2020 Financials Budget Detail (2)'[Amount] ),
'2020 Financials Budget Detail (2)'[Month] = "NOV",
'Map - Org SL MT'[Service Line] <> "abc",
'2020 Financials Budget Detail (2)'[Account] IN { "####", "###", "##" }
)

Best Regards,

Yuna

[darentengmfs]

Hi @canddig 

Can you post an example?

[canddig]

Filtered Amount - Net Rev = '2020 Financials Budget Detail (2)'[Filtered Amount - Gross Rev]

+calculate(sum('2020 Financials Budget Detail (2)'[Amount]),'2020 Financials Budget Detail (2)'[Month]="NOV",'Map - Org SL MT'[Service Line]<>"abc",'2020 Financials Budget Detail (2)'[Account]="####")

+calculate(sum('2020 Financials Budget Detail (2)'[Amount]),'2020 Financials Budget Detail (2)'[Month]="NOV",'Map - Org SL MT'[Service Line]<>"abc",'2020 Financials Budget Detail (2)'[Account]="####")

+calculate(sum('2020 Financials Budget Detail (2)'[Amount]),'2020 Financials Budget Detail (2)'[Month]="NOV",'Map - Org SL MT'[Service Line]<>"abc",'2020 Financials Budget Detail (2)'[Account]="###")

here is one of the measurements but now when I select a specific sub group this measure will not update only using the subgroup selected. Does that make sense?