Converting measures into categories - works but not with measures from datasets

[migss]

Hi, 

I have a bunch of calculated measures that I converted into categories in a table following the procedure discussed in this post:

https://community.powerbi.com/t5/Desktop/Use-DAX-Measures-as-Categories/td-p/418170. 

This worked well for measures created from tables that were imported into the model from a SQL server. I tried to use the same method with measures that were imported as part of a Power BI dataset and the new measure itself was created without any errors. However, if I use the new measure in a visual, the visual won't display and the following error message is returned:

Couldn't load the data for this visual.  OLE DB or ODBC error: Query (5, 1) The column 'Value' specified in the 'GROUPCROSSAPPLY' function was not found in the input table.

Can someone please explain to me what is causing the error and if there is a way to get around this?

Thanks.

Migs S.

[Anonymous]

Hi @migss 
I am having same problem 

Set up is following:
I have Direct Queries to 2 different datasets and one small simple table in local dataset
Visual should show ID of simple local table and measure with following definition.
As shown i am just calling measures from different datasets for different IDs of local table

Measure MTD = 
SWITCH(
    SELECTEDVALUE('Simple Table'[Id],1)
    ,1,[Total Visits GA [#]] AC] -- measure from first dataset
    ,2,[Sessions [#]]] -- measures from second dataset
)