Forum Discussion

MaxItaly's avatar
MaxItaly
Icon for Helper III rankHelper III
8 years ago
Solved

Problems creating a particular matrix (multiple dates of reference)

Hello everyone. I have some problems creating a particular matrix (and other visual objects related to this). I have a table [User], with columns [open_id] (the ID of the user), [subscription_date]...
Need Help
  • MaxItaly's avatar
    MaxItaly
    8 years ago

    I managed it somehow: I created a master calendar, linked it by subscription and unsubscription. then used these formulas:

    NumberOfSubscriptions = COUNTROWS(RELATEDTABLE('user_info'))

    NumberOfUnsubscriptions = CALCULATE(COUNTROWS(RELATEDTABLE('user_info')); USERELATIONSHIP('Master Calendar'[MasterDate]; 'user'[UnsubscribeDate]))

    so now I have the number of subscriptions and unsubscriptions for each date.

    But I'd like to avoid to use the master calendar for other purposed.

    Can someone suggest me another way to do it?

MaxItaly's avatar
MaxItaly
Icon for Helper III rankHelper III
8 years ago

I managed it somehow: I created a master calendar, linked it by subscription and unsubscription. then used these formulas:

NumberOfSubscriptions = COUNTROWS(RELATEDTABLE('user_info'))

NumberOfUnsubscriptions = CALCULATE(COUNTROWS(RELATEDTABLE('user_info')); USERELATIONSHIP('Master Calendar'[MasterDate]; 'user'[UnsubscribeDate]))

so now I have the number of subscriptions and unsubscriptions for each date.

But I'd like to avoid to use the master calendar for other purposed.

Can someone suggest me another way to do it?