How do I calculate the total for each Letter (A,B,C etc.)

[HamidBee]

Hi All,

I am struggling to write down measures that would calculate the total for each letter. For example

Total A=...

Total B=...

et.c

 

Any help would be greatly appreciated.

[amitchandak · Accepted solution]

@HamidBee , If need measure for each one ,

You can create like

A = calculate(sum(Table[Value]), Filter(Table, Table[Letter] ="A"))

B = calculate(sum(Table[Value]), Filter(Table, Table[Letter] ="B"))

[HamidBee]

Thank you, worked perfectly.