Is it possible to convert a calculated table into a hardcoded table so that you can use it for graph

[UsePowerBI]

Hello

I have a table where some columns are results of measures.

For example, if Table[Col1]='SOMETHING' then COUNTROWS(AnotherTable, with criteria etc).

The problem is that I cannot actually use IF(Table[Col1]='SOMETHING' .... ) in the measure because I get the following error:

A single value for column 'Col1' in table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

So, I understand that because the Col1 has duplicates, I need to use IF(MAX(Table[Col1])='SOMETHING' .... ) or IF(SELECTEDVALUE(Table[Col1])='SOMETHING' .... ) 

This displays the correct results of the measure in the Table however it has been impossible to create a graph out of this Table using another column, e.g. Col2 (which also has duplicates). When I drag the Col2 into the x axis and the Measure into the y axis, it displays only one value of Col2.

Do you have any fix for this please?

Thanks!

[parry2k]

@UsePowerBI post sample data and expected output, how these tabes are connected, where you are getting col1 and col2.