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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
texmexdragon2
Helper V
Helper V

how to add filter context to this measure?

Hello Community  -   I have this measure which works somewhat, but what I actually need to use instead of just the table (Bill To Customer Dim), is a specific column inside of the table (customer number).    Same for the ship to customer.   

 

I've tried a few things and am getting things like the placeholder error message.   In basic english, my goal would be to filter by something like "bill to customer dim, customer number" whereby customer number is the expression.  

 

How can this measure be modified to allow for that additional filter context?   I have the customer number on the two customer tables, so I just need to figure out how to get the measure to filter by those specific columns.  

 

PS1Date Range Distinct Count of RMAs =
SUMX (
    FILTER ( 'Bill To Customer Dim', [PSE1Date Range Measure] > 0 ),
    SUMX (
        FILTER ( 'Ship To Customer Dim', [PSE1Date Range Measure] > 0 ),
        [Distinct Count of RMAs]
    )
)

1 REPLY 1
MFelix
Super User
Super User

Hi @texmexdragon2 ,

 

Being the calculation based on a filter of the Bill to Customer Dim Table this should by default have the filter you refer to.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.