topic Re: Mixing filters in DAX Commands and Tips

Mixing filters

jmateu88 — Fri, 02 Sep 2022 16:08:14 GMT

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.

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!

Re: Mixing filters

amitchandak — Fri, 02 Sep 2022 16:53:39 GMT

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

Re: Mixing filters

tamerj1 — Fri, 02 Sep 2022 17:09:30 GMT

Hi jmateu88

You can try

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

Re: Mixing filters

jmateu88 — Tue, 06 Sep 2022 08:44:29 GMT

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!