Forum Discussion
Agregate and filter
I actually found another solution.
I have 2 tables : 1 sale detail and 1 sale header.
I found a way to create a measure in sale detail that points to the sale header using USERRELATIONSHIP.
It works.
Thanks
F
Super UserMeasures are calcilated based on context so depending on the columns you put on your visual the result will be cslculated if you add all the.coçumns to.your table you will only see the values per row if you renove columns the totals will be calculated based on that new context.
In your case if you have only the tickets and the values you will get 77.2 if you want to have the full detail ob your table the.measure can.be change however you will get the 77.2 in all rows.
So.my question is what is the.context you want on your.visual (what.columns) and if you have lots of details do.you want to get repeted values or not?
Regards.
MFelix
I would like to create a table filtered by date (SALE_DATE) and product (PRODUCT ID)
The table would include Store ID in lines and in columns :
- Nb of transactions (that's DISTINCTCOUNT(TICKET ID)
- Total amount of products filtered (SUMX(SALE AMOUNT * SALE QUANTITY)
- Total value of transactions that include the filtered product (the one measure i need help on)
Thanks a million for your help
- ChandeepChhabra
Impactful Individual
Anonymous Can you share a snapshot of the output ? Especially for the last measure
I actually found another solution.
I have 2 tables : 1 sale detail and 1 sale header.
I found a way to create a measure in sale detail that points to the sale header using USERRELATIONSHIP.
It works.
Thanks
F
