Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculation issue

Hi Team,

thanks for your time,

I am trying to create the table visual where i need a field something like Dril down calcution. But it's showing wrong calculation. Im looking 2536 but my wrong DAX formula showing 2525. Could you please help me this issue. 

DAX : GSR Billing log = SUMX(DISTINCT(AnalysisTable[Billing_Status.Billable]), FIRSTNONBLANK(AnalysisTable[Billing_Status.Billable], 0))

 

Regards,

sriram e

 

Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous try this:

     

    GSR Billing log = SUMX(DISTINCT(AnalysisTable[Billing_Status.Billable]), CALCULATE(FIRSTNONBLANK(AnalysisTable[Billing_Status.Billable]), 0))

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous try this:

     

    GSR Billing log = SUMX(DISTINCT(AnalysisTable[Billing_Status.Billable]), CALCULATE(FIRSTNONBLANK(AnalysisTable[Billing_Status.Billable]), 0))

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    Im getting syntax error. 

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous I added the parenthesis at the wrong place, try this

     

    GSR Billing log = SUMX(DISTINCT(AnalysisTable[Billing_Status.Billable]), CALCULATE(FIRSTNONBLANK(AnalysisTable[Billing_Status.Billable], 0)))

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your support. Still Im facing same issue. Calculation is wrong 

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous can you share pbix file, remove sensitive information before sharing.