DAX divsion

[Anonymous]

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

[ValtteriN]

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]

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"))