Forum Discussion

jkhan's avatar
jkhan
Helper III
4 years ago
Solved

Division in Matrix

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 Expe...
Dax commands help
Help me please
  • jkhan's avatar
    jkhan
    4 years ago

    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