Forum Discussion

Jungbin's avatar
Jungbin
Frequent Visitor
2 years ago

Divide by Filtered Measure

Hi there!

 

I made two measures and one calculated column:

 

  • Closed Amount Team = SUMX(FILTER('All Leads','All Leads'[Close Date].[Date]>DATE(2022212,31)&&'All Leads'[Stage]="Closed"),'All Leads'[Total Amount])+0
  • Closed Amount Country = CALCULATE(SUM('Orders'[Closed Amount]),'Order'[Category]="Closed")
  • Closed Amount = IF('Order'[Category]="Closed",'Order'[A]+'Order'[B]+'Order'[C])

 

, and below I described what I want to make and what I'm currently struggling with.

Can anyone help me on this?

 

 

What I want

TeamClosed Amount TeamClosed Amount CountryClosed Amount %
Sales$5,000,000$10,000,00050%
Marketing$3,000,000$10,000,00030%
Service$800,000$10,000,0008%
Others$1,200,000$10,000,00012%
Total$10,000,000$10,000,000100%

 

What I'm currently facing

TeamClosed Amount TeamClosed Amount CountryClosed Amount %
Sales$5,000,000$5,000,000100%
Marketing$3,000,000$3,000,000100%
Service$800,000$800,000100%
Others$1,200,000$1,200,000100%
Total$10,000,000$10,000,000100%
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jungbin ,

     the "Closed Amount %" for each team by dividing the "Closed Amount Team" by the "Closed Amount Country" and then display these percentages in a table.

    Closed Amount % =
    DIVIDE(
    [Closed Amount Team],
    [Closed Amount Country],
    0
    )

    • Jungbin's avatar
      Jungbin
      Frequent Visitor
      2 years ago

      Hi Anonymous, thanks for your comment.

      However, the "Closed Amount %" in my table is already a separate Measure. 

      I put that measure in PBI matrix, and it shows what I'm currently looking at.

      • selected_'s avatar
        selected_
        Helper IV
        2 years ago

        The user vs_7 are spammer and using ChatGPT and copy and paste all answer from there. He's spamming all over this forum. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jungbin ,

    Please try like:

    Closed Amount % = SUMX(SUMMARIZE('Table','Table'[Team],"C_A_T",[Closed Amount Country],"C_A_C",[Closed Amount Country]), DIVIDE([C_A_T],[C_A_C]))

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum