Forum Discussion
Measure is not working with slicer
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 of...
darentengmfs
Post Prodigy
Post Prodigy
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?