Forum Discussion

beeEc009's avatar
beeEc009
Regular Visitor
3 years ago

Slicer to filter chart using DAX

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.

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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.

  • beeEc009's avatar
    beeEc009
    Regular Visitor
    3 years ago

    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.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

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