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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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