Let's see if I can make this message clear 😉
I have a set of data, that contains User IDs and their purchasing date. I want to know how many distinct users were active (had transactions) during a month. This is easy as I just use DISTINCTCOUNT(), and get the desired result. The problem arises, when I want to filter out said users. I want to select a month to the count of the distinct users during that month AND how many of them were active during the whole observation period. For example , i want to select people that were making a purchase during the January of 2018, and then see how many of said people were active during other months. The problem is, that I need to do this using DAX functions, not querry or external data manipulation tools. ive tryed several different things, but can not seem to come to an answer. I am not a very experienced power BI user, but this is one of my latest attempts (though unsuccsesful):
Activity_users =
VAR User = DISTINCT('Papildomi pavyzdiniai duomenys Andriui'[UserId])
VAR test = "2014-01"
VAR active = IF(VALUES('Papildomi pavyzdiniai duomenys Andriui'[TransActionYM]) = test, 1 , BLANK())
VAR Grouped = SUMMARIZE('Papildomi pavyzdiniai duomenys Andriui','Papildomi pavyzdiniai duomenys Andriui'[UserId],"useriai", active)
--VAR ifactive = IF(active=1, DISTINCT('Papildomi pavyzdiniai duomenys Andriui'[UserId]),BLANK())
--VAR final = CALCULATE(DISTINCTCOUNT('Papildomi pavyzdiniai duomenys Andriui'[UserId]),active>0)
RETURN
commented lines are other attempts to this problem.
