Association not performed with Measure

[Anonymous]

Hi,

In a report page if I click the chart1 it does not associate with another chart.

my requirement is if I select any value in the chart, it should associate with another chart.

Chart 1:

Billing Status Output =

VAR _table = SUMMARIZE ( 'Week & Employee LOD', 'Week & Employee LOD'[Emp id], "_Status", [Billing Status] )

VAR _table2 = FILTER ( GENERATE ( _table, 'Billing Status1' ), 'Billing Status1'[Billing] = [_Status] )

RETURN COUNTAX ( _table2, [Emp id] )

Billing Status =

IF ([Billing Hour achievement %] = 1,"Fully Billable",

IF ([Billing Hour achievement %] < 1 && [Billing Hour achievement %] >=0.5,"Partially Billable",

IF ([Billing Hour achievement %] < 0.5 && [Billing Hour achievement %]>=0,"Non Billable","Fully Billable"

)

)

)

Char 2:

Utilization Status Output =

VAR _table = SUMMARIZE ( 'Week & Employee LOD', 'Week & Employee LOD'[Emp id], "_Status", [Utilization Statusb] )

VAR _table2 = FILTER ( GENERATE ( _table, Utilization1 ), [UtilizationV1] = [_Status] )

RETURN COUNTAX ( _table2, 'Week & Employee LOD'[Emp id])

Utilization Statusb =

IF ([Work Hour achievement %] = 1,"Fully Utilized",

IF ([Work Hour achievement %] < 1 && [Work Hour achievement %] >= 0.5,"Partially Utilized",

IF ([Work Hour achievement %] < 0.5 && [Work Hour achievement %] >= 0,"Available","Over Utilized"

)

)

)

[Anonymous]

Hi,

I checked, 

From the chart2 I changed the DAX query as following

Utilization Statusb = if([Billing Status Output]=1,

IF ([Work Hour achievement %] = 1,"Fully Utilized",

IF ([Work Hour achievement %] < 1 && [Work Hour achievement %] >= 0.5,"Partially Utilized",

IF ([Work Hour achievement %] < 0.5 && [Work Hour achievement %] >= 0,"Available","Over Utilized"

)

)

) , DISTINCTCOUNT('Week & Employee LOD'[Emp id]))

after that I click the chart1 values, association happens in a chart2

Same as I changed DAX query to chart1

Billing Status = if(

[Utilization Status Output]=1

IF ([Billing Hour achievement %] = 1,"Fully Billable",

IF ([Billing Hour achievement %] < 1 && [Billing Hour achievement %] >=0.5,"Partially Billable",

IF ([Billing Hour achievement %] < 0.5 && [Billing Hour achievement %]>=0,"Non Billable","Fully Billable"

)

)

),DISTINCTCOUNT('Week & Employee LOD'[Emp id]))

Error occurs,

it shows the error like  a circular dependency was detected

Measure: Billing status output and billing status.

[calerof]

Hi @Anonymous ,

What about if you share a sample data to check it?

F

[Anonymous]

Hi,

https://avacorp1-my.sharepoint.com/:u:/g/personal/yuvaraj_g_avasoft_com/EW8bYSSWUDJGjozdo_fWWKUBI-Ql...

if I click the chart2 it could not be associated with chart1

Any help would be appreciated

Thanks in Advance,

Yuvaraj

[calerof]

Hi @Anonymous ,

I took a look to your data and your dim tables are not related with transaction ones. You have to establish relationships in order to work with them.

Regards,

Fernando

[Anonymous]

Hi,

My requirement is based on the measure value dimension need to change dynamically.

just assume like the data as following

Date                  Working hour    Targethour      Status                           Empname

31/5/2019_fri     30                        40                Partially billable                   A

24/5/2019_fri      40                       40                billable                                 A

if I click this month, A  employee should fall under the category partially billable in a pie chart.

if working hour less than a target hour it falls under the Partially billable category

based on below URL I achieved this scenario in the pie chart.

But it could not be associated.

https://community.powerbi.com/t5/Desktop/Output-Status-as-Column/m-p/695343#M335450

Kindly look on to the measure in my sample file.

Thanks in advance 

Yuvaraj

[calerof]

Hi @Anonymous ,

Did you check Edit Interactions? Select one chart, go to Format, Edit Interactions, and the check how this chart is interacting with the rest, either filter, highlight or non.

Regards,

Fernando