Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Association not performed with Measure

 

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"
)
)
)

 

 

 

 

Need Help

6 Replies

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.