topic Re: DAX Measure calculation in DAX Commands and Tips

DAX Measure calculation

mohsinmasood — Thu, 13 Jun 2024 13:38:28 GMT

i want to calculate sum of value based on group how can i do this without creating relationship.

for example

CALCULATE(SUM('Financial Data'[Value]),BS[Group]="Bank balances and cash")

then after that i have to use this under switch like

SWITCH(SELECTEDVALUE(BS[Group]),"Bank balanes and cash",[Bank balances and cash])

i am trying these above formulas but these are not working

final outcome should be used in this visual

lbendlin — Fri, 14 Jun 2024 00:46:42 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous — Fri, 14 Jun 2024 02:47:30 GMT

The initial formula may be missing a function that correctly applies the filter context. I revised it.

BankBalancesAndCash = CALCULATE( SUM('Table'[Value]), FILTER( 'Table', 'Table'[Group] = "Bank balances and cash" ) )

Here is my preview:

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mohsinmasood — Fri, 14 Jun 2024 07:13:54 GMT

let me try this i have one more question about running sum like below example

actually i am trying to build Balance sheet so the mechanism for BS is last year sum of value should add to next year transaction