Division in Matrix

jkhan — Wed, 08 Jun 2022 06:21:36 GMT

Hi,

Please help me to build DAX to meet below requirement, I have created 2 MATRIX Visual Revenue and Expense

Account_ID starting with 4 is Revenue Account
Account_ID starting with 5 is Expense Account

So I have made Visual Level Filter for

Revenue Account_Type='Revenue' & Expense Account_Type='Expense'

I written below DAX for JAN-2022

A_JAN = CALCULATE (SUM (PBI_MIS_TB[ACTUAL]), PBI_MIS_TB[A_MONTH]=1)

Now I have requirement to get Percentage of Expense where Different Account Expenses should be divided with Total Revenue 166,801021

Example :

62,794,480 / 166,801,021

46,539,963 / 166,801,021

Below DAX for Revenue is working fine.

A_JAN% = DIVIDE( [A_JAN], CALCULATE( [A_JAN] ,ALLSELECTED()) )

But below DAX for Expense is not working correctly.

E_A_JAN1% = DIVIDE( CALCULATE ( SUM (PBI_MIS_TB[ACTUAL]), PBI_MIS_TB[A_MONTH]=1,PBI_MIS_TB[TB_ACCOUNT_TYPE]="REVENUE" ), CALCULATE( [A_JAN] ,ALLSELECTED()) )

Thanks & Regards

Jamsher

Re: Division in Matrix

jkhan — Wed, 08 Jun 2022 06:25:27 GMT

amitchandak Whitewater100

Dear Mr. Amit , Mr. Whitewater any suggestion please

Re: Division in Matrix

jkhan — Wed, 08 Jun 2022 07:41:33 GMT

Able to build the DAX working fine now.

E_A_JAN% = DIVIDE( [A_JAN],CALCULATE ( SUM (PBI_MIS_TB[ACTUAL]), PBI_MIS_TB[A_MONTH]=1,PBI_MIS_TB[TB_ACCOUNT_TYPE]="REVENUE", REMOVEFILTERS(PBI_MIS_TB)) )

Thanks & Regards

Jamsher

topic Re: Division in Matrix in DAX Commands and Tips

Division in Matrix

Re: Division in Matrix

Re: Division in Matrix