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

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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