Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
beeEc009
Regular Visitor

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: 

Screenshot 2023-03-13 121657.png

Table 2:

Screenshot 2023-03-13 121710.png

Table 3:

Screenshot 2023-03-13 122308.png

 

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 5
tamerj1
Super User
Super User

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

Hi,

Screenshot 2023-03-13 151114.png

@beeEc009 
It should work

beeEc009
Regular Visitor

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.

Screenshot 2023-03-13 145718.png

amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.