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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Im getting syntax error.