Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix issue

Created one calculated column for combining year and month. After filtering year, matrix is showing all yeras. Please help.      
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak , Pragati11 

    Removed coalesce function from measure, resolved my issue.  Thanks everyone. 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Need more information on your query.

  1. Are Year and Month columns in slicers and your matrix coming from same table?
  2. If not then what kind of relationships you have in your data model?
  3. Do you have a universal Calendar table in your data model?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pragati11 

 

Year and Month from Calendar table.

One to Many (Calendar - Fact)

Yes, I have universal calendar table.