cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Issue with Measure Behaviour

I have this base table that gets change or Revised value on basis of what if parameters :- 

PK_PBIBoss_1-1594748873467.png

Financial Item X  Account Mapping Account
Results before Tax-2.705454625TaxResults before Tax
Tax10.39512275TaxTax
Tax Rate-3.84228316TaxTax Rate
Results after Tax-13.10057737TaxResults after Tax

 

Why X + slicer measure  changes its value on addition of field under rows :- JFYI 6.62 is correct version:- 1st version is correct.

Is the issue as we are trying to refer to value Results before tax causing all the circular reference causing the error

 

Measure :- X+ SLicer :- =

VAR Topup_NetInterest = 'Net Interest Parameter'[Net Interest Parameter Value]
VAR Topup_Fee = 'Fee Parameter'[Fee Parameter Value]
VAR Topup_Other = 'Other Income Parameter'[Other Income Parameter Value]
VAR Topup_OI = Topup_NetInterest + Topup_Fee + Topup_Other
VAR Topup_Exp = 'Total Expense Parameter'[Total Expense Parameter Value]
VAR Topup_RC = 'Risk Costs'[Risk Costs Value]
VAR Topup_RBT = Topup_OI - Topup_Exp - Topup_RC
VAR Topup_LA = 'Lending Assets Parameter'[Lending Assets Parameter Value]
VAR Topup_CRWA = 'CRWA Parameter'[CRWA Parameter Value]
VAR Assumed_TaxRate = 0.14
VAR CT = CALCULATE(SUM(T1[X])+ Topup_OI - Topup_Exp - Topup_RC,WB_APAC[Financial Item] = "Results before Tax")
VAR CT_C = ([RBT_Measure]+ Topup_OI - Topup_Exp - Topup_RC) * Assumed_TaxRate

RETURN
SUMX(
'T1',
 
IF('T1'[Financial Item] = "Results before Tax" , 'T1'[X] + Topup_OI - Topup_Exp - Topup_RC,
IF('T1'[Financial Item] = "Corporate Tax" , CT_C,
IF(T1[Financial Item] = "Tax Rate", Assumed_TaxRate,
IF('T1'[Financial Item] = "Results after Tax" ,CT - CT_C,
'T1'[X]
)
)
)
)
)
 

 

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Issue with Measure Behaviour

@PK_PBIBoss - Having some issues following this. Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Issue with Measure Behaviour

Hi @PK_PBIBoss ,

 

Could you please share your sample data here if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors