Latest Enterprise DNA Initiatives

Two measures in a table that filter differently

Please help, I need to create a measure that will only flirt with the weeks slicer and the second measure will only filter with the DataName slicer.

Note: I cannot create computed tables and columns because I am using a live connection


Sample.pbix (61.8 KB)

Hi @Harris,

There are many ways you can get this functionality. Easiest way would be to use edit interaction however, sometime we may just need to create 2 sperate measures and show different result based on the selection. I have attached the solution for you. This one uses allexcept to ignore the other filter.

Hope this helps!!!Harris.pbix|attachment (63.6 KB)

Harris.pbix (63.6 KB)

The idea behind this is that I can select a range from the datenameslicer filter and I will get a result ONLY in the measure Units (datenameslicer), while if I select a week from a slicer that does not have to be in the selected range from datenameslicer, I will get ONLY a result in the measure Units (weekslicer)

Harris.pbix (63.7 KB)

Hi there,

I solved this issue as I understood and attached the file.

Simply, I wrote DAX Formula:

Total Units = Calculate(Sum(Sales[Units])
Then, I used Filter Visual option.

By the way, I hope the following video will help you to understand this issue deeper:

Good luck.

Forum_Zarbaliyev_Slicers_Sample.pbix (63.8 KB)

It wasn’t about that. One measure is to be filtered from DataNameSlicer only and the other measure from WeekSlicer. You want the two measures to be in one table visualization. Previously, @AnshP did this almost well, but the slicers were interdependent and shouldn’t be

Again: I have a Units (datenameslicer) measure which should only filter on the dataname and the second Units (weekslicer) measure should only filter on the weeks slicer. For example, I would like to select the period from the DataName filter, e.g. 10.10.2020-12.12.2020, to get the result only in the measure Units (datenameslicer) and in the slicer with weeks, for example, select the 20th week of 2020, get the result only in the measure Units (weekslicer), so that was to be compared between these measures.

Note: I cannot create computed tables and columns because I am using a live connection | Both measures must be in one table visualization

week filter.pbix (62.5 KB)

i believe you can’t have two kinds of filter pulling different information in one table calculation…you will need to separate them into two

1 Like

Hi @Harris , we’ve noticed that no response has been received from you since the 6th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!