Forum Discussion

mohsinmasood's avatar
mohsinmasood
Frequent Visitor
2 years ago

Financial Statements Dax Measures

I have financial statement format for that i am using measures with switch to display the value but one of the measures is not giving me right value when placed with switch function alone that measur...
Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

Hi mohsinmasood 

 

Please use the code formatting, this makes it easier to read measures.

Looking at the screenshot of the table, Reserves doesn't appear in the Group column. You need to add it there for it to appear.

 

Hope this helps

Joe

mohsinmasood's avatar
mohsinmasood
Frequent Visitor
2 years ago

"Reserves"its there actually i just took random screen shot just for understaning 

  • mohsinmasood's avatar
    mohsinmasood
    Frequent Visitor
    2 years ago

    It gives me value of this calculation

    Reserves = CALCULATE(SUM('Financial Data'[Accounted Net]),ALL('Financial Data'[Accounted Net])

     

    but i want below calculation value

    Reserves = CALCULATE(SUM('Financial Data'[Accounted Net]),ALL('Financial Data'[Accounted Net]),'Financial Data'[Group dUPLICATE acc type]="Owners' equity")+[Net Profit for Equity]