Forum Discussion

fsfs's avatar
fsfs
Helper I
5 years ago
Solved

problem while multiplying column by measure (doesn't work)

Hello champs!   To give you initial context: - I'm working on stock exchange data - the dim table contains purchases (ticker, amount, price, date, currency, etc) - the fact table contains all pr...
  • fsfs's avatar
    fsfs
    5 years ago

    I think I might have figured it out

     

    the problem that I had seemed to be because I was mixing the facts (hardcoded data in columns) with the measures in a one measure, in which case the measure tend to have a single value (like with VAR statement)

     

    I fixed it with turning the facts into measures with
    ( CALCULATE ( SUMX ( table, column_that_i_needed_elsewhere_as_measure), FILTER( calendar_table, calendar_table[date] = MAX(calendar_table[date]) ) ) )

    and it seems to work as intended

fsfs's avatar
fsfs
Helper I
5 years ago

I think I might have figured it out

 

the problem that I had seemed to be because I was mixing the facts (hardcoded data in columns) with the measures in a one measure, in which case the measure tend to have a single value (like with VAR statement)

 

I fixed it with turning the facts into measures with
( CALCULATE ( SUMX ( table, column_that_i_needed_elsewhere_as_measure), FILTER( calendar_table, calendar_table[date] = MAX(calendar_table[date]) ) ) )

and it seems to work as intended