can't display the visual - matrix

[Anonymous]

I built this measure and was trying to use it in the matrix but I got this message, what is the peroblem? How can I fix it? 

Note that month is a new column was generated by as: month =format('table'[INVOICE_DATE], "MM"). Days is also a new column that was generated as: days = if(DATEDIFF('Table'[INVOICE_DATE],'Table'[PAYMENT_DATE], DAY)<= 30,"30", IF(DATEDIFF('Table'[INVOICE_DATE],'Table'[PAYMENT_DATE], DAY) <=60, "60", "90+" ))

Matrix I am trying to conduct contains month in the rows , measure 30, 60, 90 as values.

Measure 30 generated as abvious in the screenshoot.

[Anonymous]

Hi @Anonymous ,

Please check what the data type of your calculated column [Days] is and make sure it is not in text format but in a format that can be used for calculations such as whole number.
Click on [Days], find column tools in the toolbar, and check your data type.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]

@Anonymous thank you, I fixed it but i got wrong results. 

[Anonymous]

Hi @rbahar006 ,

How do you expect the output to look like?

Sample data without sensitive information and expected output would help tremendously.

Best Regards,
Community Support Team _ Caitlyn