Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Split values based on duplicate references

Hello I am trying to get the final sale (after discounts), but in my current table each sale that has more than one product the total discount of the sale is repeated on each line generating tha...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI cecitorresHF,

If you are work with the default aggregation function of raw table fields, it is impossible to achieve your requirement, I think you need to use DAX expressions to write a formula.

Can you please share some dummy data with a similar data structure and expected results? It will help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Here I add a screenshot of what I'm looking to do, basically I need to create a column in the data table (discount) in which the discount is divided by the number of products purchased by sale (code), so that in the end the sales table looks like in the following image

    cecitorresHF_0-1620256416658.png

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      You do not need to create a discount column for that.  To your Table/matrix table visual, just drag The Reference field and write this measure to get the discount

      Discount = min(Data[Sale discount])