Forum Discussion
Product combination per customer
Most Valuable ProfessionalHey Bertverderrie ,
it would be easier if you could share the file. Is that possible?
Be aware when you do this as a calculated column, the values are fixed. So calculated columns won't change when you change a slicer. As the table Dim_Klant doesn't contain any date rows, this solution with the calculated column in Dim_Klant won't work.
So I think you should in the report create a matrix with the customer and date on the rows and as a measure you count the amount of data available.
Something like this:
myMeasure =
CALCULATE(
COUNTROWS( Fact_CR_historisch_actief ),
Fact_CR_historisch_actief[Contractwaarde einde periode] > 0
)
But again, I can just guess as I don't see the data model and also the result is not totally clear for me.
selimovd
Did you manage to crack it?
- selimovd
Hey Bertverderrie ,
I don't really see why you want to do a measure or calculated column.
You can solve that with slicers and a matrix.
You can filter for the date, product family and see which customer has which amount of specific products at the given time:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi selimovd ,
Maybe I can show you why,
I've added the desired column to the sample excel..
I want to track the amount of clients that were under contract with a certain combination of products at any time. In order to get a visual looking something like thisSample file here
(im aware this visual shows only the number of products, not unique customers but you get the idea)- selimovd
Bertverderrie "sorry, this download link no longer exists :("