Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Sum

Hi, I want to get sum of some rows from a given data set. I can better explain my query from the following example.   In the image attached, I have a dataset containing three names A, B, and ...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Try to create those measures.

    A = CALCULATE(SUM('Table'[Value]),'Table'[Name]="A")
    B = CALCULATE(SUM('Table'[Value]),'Table'[Name]="B")
    C = CALCULATE(SUM('Table'[Value]),'Table'[Name]="C")
    D = calculate(Sum('Table'[Value]), filter(allselected('Table'), [Date] = max('Table'[Date])  && [Name] in {"A", "B"} ) )
    ratdio = [D]/[C]

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Thanks for the quick update.

"I have absolutely no clue how this should or would be tackled in Power BI" - what is most important is the result that YOU want.  

I can see in the updated data posted that there is already a desire to combine the A,B result into the A column. Is it relevant to show the other lines?

Maybe you want a result like this

Date  Cond_Sum

25th 23

26th 31

27th 59

I'm not around for a few hours but will respond later if you need more help.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes. The other Curves are still required. As a matter of fact, I want to add the values of the Curves A and B. Let's say the new curve name is D. 
Then, I will divide D by C. This will give us an important ratio which we wanted to show in our dashboard.