Using GENERATE with conditional columns

[gvg]

Hi experts,

I am trying to put up a chart that displays Amount by different category, which is selected in a slicer. For example, if user selects Client in the slicer, the chart displays sales by client. If Manager is selected - accordingly the same chart displays sales by manager. For that reason I thought I'd build a new table with additional field ChartFld, that will be used as category in a pie chart. But for some reason I can't get it work. For some reason IF results in False even if value "Client" is selected in the slicer.

Here is my tSales table, result table and the slicer:

Here's my table definition:

ChartTable = GENERATE(tSales,ROW("ChartFld",IF(SELECTEDVALUE(mySlicer[Column1])="Client",[Client],[Manager])))

What am I doing wrong here?

[Greg_Deckler]

Can you post some sample/example data that can be easily copied of your source data and perhaps a diagram of relationships.  Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[gvg]

@Greg_Deckler

Thanks for advise. Here's the link to pbix example in question.

[gvg · Accepted solution]

It looks like it is impossible to build a table like that as, according to Marco Ruso, calculated tables ignore any filter selections.