Forum Discussion

TcT85's avatar
TcT85
Helper III
9 months ago
Solved

Filter on table visual

Hi,       I'm using two table visuals (not database tables): Table 1 displays data from all our test equipment for today. Table 2 shows data from the last 30 days. What I want is: when...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    9 months ago

    Hi TcT85, 
    Thanks for the follow-up question.

    I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome: 

    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

Shubham_rai955's avatar
Shubham_rai955
Super User
9 months ago

Create this measure in your data model:

 
Yield_Filtered_30Days = CALCULATE( SUM(YourTable[Yield]), -- Or your original measure ALLEXCEPT( YourTable, YourTable[Equipment], YourTable[Product] ) )

Why this works:

  • Keeps filter context on Equipment and Product.

  • Removes any filter on Date, so Table 2 continues to show 30-day history.

  • No changes needed to relationships or visuals.

How to use:

  • Use this measure Yield_Filtered_30Days in Table 2 instead of original Yield.

  • Clicking a row in Table 1 applies filters only on Equipment and Product.

TcT85's avatar
TcT85
Helper III
9 months ago

Hi Shubham_rai955 

I have tried your measure but I cant get it to work, maybe I have explained my issue to vague, I have updated my message above for better clarification, sorry for the inconvience.