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
Vivenna
Regular Visitor

Measure/Filter applied to a slicer

Hello!

 

I have a currency dimension and a currency fact table. The currency dimension contains 100 keys, tickers and names. The fact table has the average exchange rate for every day but doesn't contain exchange rates for all tickers in the dimension. CurrencyID is connected to FactCurrencyID.

 

Vivenna_0-1667051161020.png  

Vivenna_1-1667051218311.png

 

I am using a slicer "CurrencyName from the dimension to convert values, but since not every name/ticker appears in the fact table, many are blank and I would like to have it so that my slicer only shows the currencies that appear the fact table.

 

One option is to manually select the currencies I want to appear through the filters panel, but this is static and I would like a dynamic measure that will change if/when new currencies are added to the fact table.

 

I believe the logic would be like "if Currency[CurrencyID] is found in FactCurrency[FactCurrencyID], then show Currency[CurrencyName], if not then ignore.

 

Is it possible to do something like this with dax?

 

Thanks!

2 REPLIES 2
eliasayy
Impactful Individual
Impactful Individual

Hello @Vivenna 

Can you please share a sample of the data

@eliasayy  Hi and I'm sorry for such a late response.

The data itself is sensitive so I can't sample it.

 

The images in my first post describe the relevant columns in each table. My currency fact table is joined to the date table.

 

I am using a slicer which has currency name from the currency dimension and I wondered if it was possible to apply a measure as a filter to the slicer, so it only shows currency names that appear in the fact table.

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.

Top Solution Authors