Forum Discussion

Post Partisan

2 years ago

Matrix Design

Hello I would like to design a Matrix. Is it possible to have 2 columns with the same data. The data is from Direct Query. - One with higher than version 2.x - One with less than version 1.9 Do ...

Tips and Tricks

Super User

2 years ago

In this case being in Direct Query, the best option is to create the measures since you have the values on a specifc column.

Post Partisan

2 years ago

Hello

Thank you

I get this error

The script is

_Teams_Mac_lt_2.0 =

CALCULATE(

COUNTA('CQD'[Second User Agent Category]),

'CQD'[Second User Agent Category] IN { "Microsoft Teams Mac" }

)

Regards
JFM_12

Anonymous
Not applicable
2 years ago
Hi Heinrich ,

Based on the error message, Please check if the problem occurs with some data type conversions.
Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Fabric Community
Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Fabric Community

In some cases, clearing permissions in the data source settings and re-entering the credentials can solve the issue.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
- Heinrich
  Post Partisan
  2 years ago
  Hello Gao
  Thank you very much for your answer
  Unfortunately it is in Direct Query.
  
  Everything works as Table but Matrix gives me more flexibility and
  better big picture over a Table.
  
  Regards
  Heinrich

Related content