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

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