Forum Discussion
Solved
DAX DIVIDE function/expression with one column?
Hello, I am new to power BI DAX constructs and would like some help. Task is to simply divide items within a single column. Is this possibe? For example - given the grid below, take New lable ...
I think your best bet is going to be to clean your data. As a general rule, you shouldn't have values and aggregated totals in the same column. If you took out the Totals from that column, you could use this DAX:
column= [Total Purchase] / SUM([Total Purchase]) *100
If you're unable to clean the data, I suggest trying the CALCULATE function (click here to read more).
I think your best bet is going to be to clean your data. As a general rule, you shouldn't have values and aggregated totals in the same column. If you took out the Totals from that column, you could use this DAX:
column= [Total Purchase] / SUM([Total Purchase]) *100
If you're unable to clean the data, I suggest trying the CALCULATE function (click here to read more).
Agreed. Best bet certainly looks like cleaning the data. Thanks a ton!
