Reid - How would you handle a scenario where your Order Date is in an inactive relationship with the date table? That is our setup...we use "due date" as the active date table relationship between our sales table and our date table. Can USERELATIONSHIP be inserted somewhere in these measures?
I wouldn't think you'd need to? If you're calculating the first date off the fact table in the first variable. It isn't reliant on a relationship yet. Just retrieving that date. Have you tried it using your Due Date and what was the results? It's been about three years since I published this so a little rusty on the logic, haha.
This is very helpful. I am trying to achieve the same thing but instead of single select, I want to have multi-select on a measure.. How can I achieve that?
Definitely, but the measure filter would be a different setup than this video, where the goal is just to filter the slicer below it. Measures can filter basically any visual as long as it's filters are configured correctly to result (usually) in a 0 or 1 flag, then add that as a visual filter and = 1
@@HavensConsulting Can you give a quick idea of what those changes would be? Can the same measure filter be used to drive results on BOTH the table and visual?
@@uniquemonikor unfortunately I'd need to revisit the file and the calculations. I made a note to follow up with it but it'll be a while before I'll have time to dig into the file from this video (it's been a few years since I made it)
Great video. I have downloaded the pbix file and in the measure [New/Returning Customer Flag ] the VAR ReturningCustomer = AND( NOT(FirstOrderDate >= MinFilteredDate); FirstOrderDate
Certainly! Unfortunately I don't have the time to write out the measure to do this in DAX. But this is something that can certainly be accomplished through a combination of CALCULATE and applying some filters to account for New/Returning
@@HavensConsulting Hi, like Adam asks, i tried to write this measure to count the number of customers, but i have a error message because i would like to filter on a measure : CALCULATE( DISTINCTCOUNT(Data[CustomerName]), [New Returning Customers Toggle]=1) Could you help me please ?
@@coollehavre If you use a measure in the filter section of calculate. You'll need to use the FILTER function for advanced filter scenarios (such as filter by measure). regular filters need to be boolean.
Hi, i tried this : Nb customers Statut = CALCULATE(DISTINCTCOUNT(Data[Customer Name]),FILTER(Data,[New/Returning Toggle]=1)) he gives the number total of my customer ?
Si buscás la información abajo de la descripción ,está la dirección al blog del autor. Hay que registrarse (dar el email ) y te manda el password para acceder al blog adonde está el file.
Hi Sohail, glad you liked the video. If you expand the video description there is a link to a Blog Files page that will have the PBIX file. If that is your first time visiting the page it asks that you sign up for my email newsletter. Which will also send you the password to get onto my Blog Files page.