Forum Discussion

msmays5's avatar
msmays5
Helper II
5 years ago
Solved

Cross Filter Multiple Fact Tables

Hi everyone,   I have the following tables, plus a date table (fact tables in green, dimension tables in yellow)   There are the following relationships: 1. 'Articles'[ArticleID] --> 'Arti...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    msmays5 , although your senario isn't that logical (the Article Views table doesn't have a country identifier), I came up with a solution in line with your description; you might want to refer to the attached file for details.

    Measure = 
VAR __articles = CALCULATETABLE ( DISTINCT ( dArticle[ArticleID] ), CALCULATETABLE ( fTag ) )
RETURN
    DIVIDE (
        SUMX (
            __articles,
            VAR __prev =
                CALCULATE ( [Views], PREVIOUSMONTH ( dDate[Date] ) )
            RETURN
                 ( [Views] > __prev ) + 0
        ),
        [# of Articles Visible to Country]
    )

ctaulbee's avatar
ctaulbee
New Member
5 years ago

It's a little hard to follow what you're hoping to accomplish. Not sure what you mean by an incremental view.

 

If you have cumulative counts by month in your first fact table, does that mean if you simply sum 2 months you'd be double counting the first month?

 

Also, you have no country identifier in your first fact table, so if you take a sum of the article views and divide it by total number of countries who had access to that article, what would that tell you?