slice from other tables - CUMULATIVE active users

[ILAN102010SH]

hello,

I used this dax for making a chart of active users by month.

the dax workd fine by creating a calnder table and and inserting this dax in this table.

the problem is when I try to slice it on service_discription or segment fields on other tables.

it makes a hole it the chart for months that not appear on the field Effective_date

please see the tables here and the dax.

please your help.

ActiveUser = 
var currentdate = MAX('Calendar'[Date])
return

CALCULATE(COUNT('ServicePeriod'[Subscriber]),FILTER(ALL(ServicePeriod),OR('ServicePeriod'[Effective_Date]<=currentdate&&'ServicePeriod'[Expiration_Date]>=currentdate,'ServicePeriod'[Effective_Date]<=currentdate&&ISBLANK('ServicePeriod'[Expiration_Date]))))

[v-caliao-msft]

@ILAN102010SH,

"it makes a hole it the chart for months that not appear on the field Effective_date"

This is caused by that you do not have any active users in that month. If you do not want to show the empty month, you can create a calculated column and use it in yout visual axis.
Column = FORMAT('Calendar'[Date],"YYYYMM")

Regards,

Charlie Liao

[ILAN102010SH]

Hello Charlie,
Thank you for your reply.
There are active users in that month.
Active user= has no end date for this months.
The problem that nobody joined this months.
The graph need to show the current of users by this months.
Is there any solution to that?

[ILAN102010SH]

this what appears when I make a slice on fields from other tabls of segmnt or service_dicription

please help me!

Will be very appriciated.

Best Regards,

[ILAN102010SH]

@v-caliao-msft in advance to your wonderful solution to my problem earlier, I have another question, please look up, please your kind help. Kind Regards. Ilan-S

[v-caliao-msft]

@ILAN102010SH,

Could you please provide us more detail information about your report? Do your use this measure in your visual? Provide us some sample data so that we can make further analysis.

Reards,

Charlie Liao

[ILAN102010SH]

@v-caliao-msft

this is a link for the PBIX file.

https://drive.google.com/open?id=0B5bWrOi7vuVWemlYaWwta0lMMW8

can you open it?