Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX divsion

Hi All,

I need help to know the dax that I can use to calculate this table.  The Completed column is a dax derived from the main table. 

Seen  Completed

No       2

Yes      98

NA     2

total  102

I want to have a division of each row from the total . For example, 2/102, 98/102

Need Help

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi,

    Here is one way to do this:

    DAX:

    Divide by total =

    var _total = CALCULATE(SUM('Table (6)'[Completed]),ALL('Table (6)')) return

    DIVIDE(SUM('Table (6)'[Completed]),_total)

    End result:

     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks Valtterin,
      The issue that I have is that I already have a filter which must be used to show the completed before the calculation is applied and using ALL will remove the filter and will be showing everything thereby giving wrong figures.  How do I apply your fomular with the below

      CALCULATE(SUM('Fact'[RowCount]),
      FILTER(Step,Step[step_status]= "Com"))