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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jmateu88
Helper I
Helper I

Mixing filters

Hello,

What I am looking for is filter a week and check which machines were repaired and how many times these were repaired in all the registers in the table.

 I know how to do it setting filters in the visualizations but I am sure that mixing some DAX expressions is possible to do it in an easier and correct way. I was not able to get this combo 😞

I prepared an example to simplify it. In the example, we can see which would be the solution for each week filtered.

Screenshot_3.jpg

The solution should filter the machines in the week selected but, without filter if they appear in another week to be able to accumulate the times these were repaired.

 

This is for a bar chart.
Thank you very much in advance!

3 REPLIES 3
jmateu88
Helper I
Helper I

Hello @tamerj1  and @amitchandak  and thank you for quick answer.

Logic:
I am trying to obtain some details of the electrical trips in different machines (to simplify it, I said machines).
The details I am looking for are, during the last week:
     - how many trips there were (a simple count)
     - how may we have accumulated (simple count + "removefilters" for weeks)
     - and the last one that I am asking for is to prepare a plot with all the trips registered BUT only for the machines we had a trip during last week.

It is for this reason I do not want to see the accumulate of all machines but, only for those that had a trip during last week.

The solution of @tamerj1 works great! is almost perfect but has a small issue. I cannot use the dimensions. I have to use the fields which are in the fact table. I would prefer to use the filter of the week from the week dimension.

 

Thank you again in advance!

tamerj1
Super User
Super User

Hi @jmateu88 

You can try

Count = COUNTROWS ( CALCULATETABLE ( Fact, ALLEXCEPT ( Fact, Fact[Machine] ) ) )

amitchandak
Super User
Super User

@jmateu88 , can you explain the logic, why machine 1 is 3 in week 1

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.