DAX Measure calculation

[mohsinmasood]

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 

[Anonymous]

Hi, @mohsinmasood 

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:

How to Get Your Question Answered Quickly

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]

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 

[lbendlin]

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-...

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/1447...