Matrix Design

[Heinrich]

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 I have to do a Measure or can it be done easier?
Once it is done I would also like to drill down to see who has one of the 2 versions.
Can I insert the drill down and add the User into the "Drill through" field
Regards

Heinrich

[MFelix]

Hi @Heinrich ,

Can you elaborate a little bit more on the:

- One with higher than version 2.x

- One with less than version 1.9

Does this information already exists on your model or you only have a single column?

[Heinrich]

Hello Miguel

I have one single column.

In this column "Versions" you have different Versions.

This column (String) has following data

Version 1.1

Version 1.2

Version 1.3

Version 2.1

Version 2.2

Version 2.3

Version 2.4

I could limit it to 

- 1 Measure to search only 1.2

- 1 Measure to search only 2.3

Every Data is on Direct Query

Thank you for your help

JFM_12

- 

[MFelix]

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

[Heinrich]

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

[v-cgao-msft]

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]

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