Forum Discussion
Calculated table with filters
Hi
I'm not sure if i've understood your problem fully, but try the following.
Create a new column with the following calculation:
IF CustoemrOrderSeqNo = 1 THEN "New" ELSE "Existing" ENDIF
Now you can make a single-select slicer and choose whether you want to see new or existing customers in your list. So first choose date interval, then choose if you want to see new or existing customers in your visualization.
Let me know if this helps.
Hi Anonymous
Thanks for your suggestion.
Unfortuantely this doesnt work in my case since the status of the customer changes according to the filter selection of the date. The column only provides a static view of the customer's status at just one point in time whereas mine needs to be dynamic.
afk
Hi bo_afk ,
For a dynamic view of the customer's status, I think you can create a measure like this:
Measure 2 = RANKX(FILTER(ALLSELECTED('Test'),Test[CustomerID]=MAX(Test[CustomerID])),CALCULATE(SUM('Test'[date])),,ASC)
The results are as follows:
Here is a demo , please try it：
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
