Slicer to filter chart using DAX

[beeEc009]

Hi all,

I'm trying to create a chart to return net actual vs budget chart using fields in multiple tables.

Table 1: 

Table 2:

Table 3:

Relationship:

Table1(Mapping) - Table 3(ExecutivePL)

Table 3(Mapping Key) - Table2(Mapping Key)

Question

I have created a DAX measure to returns net actual:

Actual Net Result =

CALCULATE(

    SUM('Table 2'[Value]),

    'Table 2'[Header]="Actual"

)

How do I filter measure to show Net Actual for Table1 [Line item]? So chart returns only sum of actuals for e.g Utilities when selected. Thanks.

[tamerj1]

Hi @beeEc009 
Please provide a screenshot of the relational data model view to understand there lationships between the tables.

[beeEc009]

Hi,

[tamerj1]

@beeEc009 
It should work

[beeEc009]

Thank you for the prompt response. I assumed that the chart should filter if slicer is added but that hasn't been the case.

there is no direct relationshipship between table 1 and table 3. It is worth mentioning that carries data labels, table 2 is a mapping table and table 3 holds all the data (fact table)- this is a new project and I just recently took over. 

To simplify my request, i will attach a screenshot of how i will like my output to look.

[amitchandak]

@beeEc009 , If table 1 is on the one side of the join, you should be simply able display this measure and column from table 1

In case of other join is should also work

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.