Re: Power BI DAX: Measure Shows Total, But not wor...

SG_45 · ‎10-29-2025

I need to calculate project budget in my table visual which should displays its total budget completely irrespective of any Period Year filter applied by the user. Below measure is working fine for total but not working on granular level in table as expected.

As, I'm showing other values such actuals and forecast in the table, I can't remove interaction directly.

So, I tried using Removefilters but it is also not working properly. When the Period Year slicer has all values selected, the Project Budget measure shows correct values in all granular rows.

But when I apply any filter it will show some descrepancy.

Bulk graphic

Type

Data Source

Provider Type

Supplier

Operation Type

Operation Type Name

Topic Owner

Project ID

Topic Manager

Topic Controller

ARE Owner

ARE Owner unconsolidated

Net Cost EUR

M Net Cost EUR unconsolidated

Project

Budget

Provider

I

SuppX

1

Consulting

Owner_A

PA001

Manager_X

Controller_1

ARE_X

ARE_Y

1000

Project

Budget

Provider

I

SuppX

1

Consulting

Owner_A

PA001

Manager_X

Controller_1

ARE_X

ARE_Y

1000

Project

Budget

Provider

I

SuppX

1

Consulting

Owner_A

PA001

Manager_X

Controller_1

ARE_X

ARE_Y

1000

Project

Actual

Provider

I

SuppX

1

Consulting

Owner_A

PA001

Manager_X

Controller_1

ARE_X

ARE_Y

500

Project

Budget

Provider

E

SuppY

2

Software

Owner_B

PB002

Manager_Y

Controller_2

ARE_Y

ARE_Z

2000

Project

Budget

Provider

E

SuppY

2

Software

Owner_B

PB002

Manager_Y

Controller_2

ARE_Y

ARE_Z

2000

Project

Budget

Provider

E

SuppY

2

Software

Owner_B

PB002

Manager_Y

Controller_2

ARE_Y

ARE_Z

2000

Project

Budget

Provider

E

SuppY

2

Software

Owner_B

PB002

Manager_Y

Controller_2

ARE_Y

ARE_Z

2000

Project

Actual

Provider

E

SuppY

2

Software

Owner_B

PB002

Manager_Y

Controller_2

ARE_Y

ARE_Z

1000

Project

Budget

Provider

S

SuppZ

3

Hardware

Owner_C

PC003

Manager_Z

Controller_3

ARE_Z

ARE_X

3000

Project

Budget

Provider

S

SuppZ

3

Hardware

Owner_C

PC003

Manager_Z

Controller_3

ARE_Z

ARE_X

3000

Project

Budget

Provider

S

SuppZ

3

Hardware

Owner_C

PC003

Manager_Z

Controller_3

ARE_Z

ARE_X

3000

Project

Actual

Provider

S

SuppZ

3

Hardware

Owner_C

PC003

Manager_Z

Controller_3

ARE_Z

ARE_X

1500

Project

Actual

Provider

I

SuppA

1

Consulting

Owner_D

PD004

Manager_A

Controller_4

ARE_X

ARE_Y

100

Project

Actual

Provider

I

SuppA

1

Consulting

Owner_D

PD004

Manager_A

Controller_4

ARE_X

ARE_Y

200

Project

Budget

Provider

I

SMO_088888

1

Consulting

Owner_E

PE005

Manager_B

Controller_5

ARE_Y

ARE_Z

5000

Project

Budget

Provider

I

SMO_088888

1

Consulting

Owner_E

PE005

Manager_B

Controller_5

ARE_Y

ARE_Z

5000

Project

Budget

Provider

I

SuppB

RDCB

R&D Budget

Owner_F

PF006

Manager_C

Controller_6

ARE_Z

ARE_X

6000

Project

Budget

Provider

I

SuppB

RDCB

R&D Budget

Owner_F

PF006

Manager_C

Controller_6

ARE_Z

ARE_X

6000

</>

Project Budget =

VAR SelectedConsolidation = SELECTEDVALUE('Consolidation_flag'[Consolidation view - Copy])

RETURN

SWITCH(

TRUE(),

SelectedConsolidation = "Switch to ARE Consolidated view",

COALESCE(

CALCULATE(

SUM('Final data'[Net Cost EUR]),

'Final data'[Bulk graphic] = "Project",

'Final data'[Type] = "Budget",

'Final data'[Data Source] = "Provider",

'Final data'[Provider Type] IN {"I", "E", "S"},

NOT 'Final data'[Supplier] IN {"SMO_088888"},

NOT 'Final data'[Operation Type] IN {"RDCB", "9"},

REMOVEFILTERS('Final data'[Period Year])

),

0

),

SelectedConsolidation = "Switch to World Consolidated view",

COALESCE(

CALCULATE(

SUM('Final data'[M Net Cost EUR unconsolidated]),

'Final data'[Bulk graphic] = "Project",

'Final data'[Type] = "Budget",

'Final data'[Data Source] IN {"Provider", "Receiver"},

NOT 'Final data'[Supplier] IN {"SMO_088888"},

NOT 'Final data'[Operation Type] IN {"RDCB", "9"},

REMOVEFILTERS('Final data'[Period Year])

),

0

),

0 // Default if consolidation flag is blank or unmatched

)

</>

SG_45 · ‎10-29-2025

Thanks for replying I haved the data.

The Core Problem :
I need a Project Budget measure that, for each project in my table visual, displays its total budget completely irrespective of any Period Year filter applied by the user.

When I apply a filter on Period Year using a slicer, the individual rows for the Project Budget measure either show blank values or incorrect/discrepant numbers. However, when all Period Year values are selected in the slicer, the measure works perfectly at the granular level.

Key Constraints:

I cannot simply remove visual interactions for the Project Budget measure. Other measures (like Actuals and Forecast) in the same visual must respond to the Period Year slicer. This means the solution must be entirely within the DAX measure itself.
Data Model Context:

My main fact table is 'Final data'.
My table visual has Project Name (or similar project-level attributes) in its rows.
The Period Year slicer is directly filtering 'Final data'[Period Year]. There is no separate Date/Calendar table involved for Period Year.

My Observations:

I've used REMOVEFILTERS('Final data'[Period Year]) within the CALCULATE function, but the problem persists as below-->
When the Period Year slicer has all values selected, the Project Budget measure shows correct values in all granular rows.
When a specific Period Year (e.g., "2025-P01") is selected in the slicer, the total for Project Budget is correct, but individual rows are either blank or show incorrect numbers.
I have created Actuals and Forecast wiith same logic but this are calculated Period Year wise while Budget is declared once in a year so it should ignore Period Year slicer basically.

v-hjannapu · ‎10-31-2025

Hi @SG_45,

Thanks for sharing the details. From your explanation, it seems the Period Year slicer is still impacting the Project Budget numbers even though you’re trying to ignore it. This usually happens because of how Power BI handles filter context inside visuals.

Since other measures like Actuals and Forecast need to respond to the slicer, the solution has to be adjusted carefully in the DAX so that only the Budget ignores the Period Year. If the issue persists, please provide a sample dataset so we can assist you with a solution.

Regards,
Community Support Team.

SG_45 · ‎10-31-2025

Hi, I have already added a sample data. Is it not visible?

v-hjannapu · ‎11-02-2025

Hi @SG_45,

I have reproduced your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.

Regards,
Community Support Team.

v-hjannapu · ‎11-08-2025

Hi @SG_45,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

SG_45 · ‎11-09-2025

Hi, Thank you for your response. I'm already using RemoveFilters function but it is not helping. It is not working properly.

v-hjannapu · ‎11-10-2025

Hi @SG_45,

Thanks for the update. Can you please share your PBIX file? It will help us check the setup and understand why the issue is happening. Once we review it, we can guide you with the right solution.

Please make sure the file doesn’t contain any confidential information before sharing.

Regards,
Community Support Team.

v-hjannapu · ‎11-16-2025

Hi @SG_45,
could you please share your PBIX file, It will help us check the setup and identify the issue clearly.
we can guide you with the right solution.

Regards,
Community Support Team.

lbendlin · ‎10-29-2025

Make sure that REMOVEFILTERS also covers related items like sort columns. Use FILTERS() to probe which ones are currently applied.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...