Forum Discussion

Frequent Visitor

3 years ago

Solved

Simple DAX calculations help needed

I have a Table named Sales, in this table there is 1st column named QTY SOLD, 2nd column column SALES PRICE, 3rd column TOTAL SALES BEFORE DISCOUNT (qty sold x sales price) and 4th column TOTAL SALES...

Need Help

Tutorial Requests

ribisht17
3 years ago
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Thanks,

Ritesh

VahidDM

Super User

3 years ago

Hi Jacklyn

Try thesemeasures:

discount $ = SUM(Sales[TOTAL SALES BEFORE DISCOUNT])-SUM(Sales[TOTAL SALES AFTER DISCOUNT])
discount % = DIVIDE([discount $],SUM(Sales[TOTAL SALES BEFORE DISCOUNT]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!