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.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
9 months ago

Hi TcT85,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to Praful_Potphode, Shubham_rai955, grazitti_sapna, PijushRoy, for those inputs on this thread.

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

Sample data: 


Dax Measures: 

Yield Today: 

Yield Today = 
DIVIDE([Pass Today], [Pass Today] + [Fail Today])


Pass Today: 

Pass Today = 
CALCULATE(
    SUM(Data[Pass]),
    Data[Date] = DATE(2025,11,6)
)


Fail Today: 

Fail Today = 
CALCULATE(
    SUM(Data[Fail]),
    Data[Date] = DATE(2025,11,6)
)

 

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.

TcT85's avatar
TcT85
Helper III
9 months ago

hi v-kpoloju-msft 

I got to it work with the fictional datatable i shared with you, but when i try with my real data it''s not working.

Is it because the data is in this order ?

EquipmentProductSerialNumberStatusDate 
Test111110001Pass2025-11-07 
Test111110001Fail2025-11-06 
Test111110002Pass2025-11-06 
Test122220003Pass2025-11-06 
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    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.

    • TcT85's avatar
      TcT85
      Helper III
      9 months ago

       

      v-kpoloju-msft 

      Now it's working!

      Thank you for the amazing support.