Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table that looks like this:
MyTable | ||
MyColumn1 | MyColumn2 | MyColumn3 |
10-Aug | Value 1 | X |
10-Aug | Value 2 | |
10-Aug | Value 1 | X |
11-Aug | Value 1 | |
11-Aug | Value 2 | X |
12-Aug | Value 1 | X |
I have a slicer on MyColumn2 (contains two values - Value 1 and Value 2)
I have a calculated column that looks like:
MyColumn 4 = COUNTROWS(
FILTER('MyTable' ,
'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= earlier('MyTable'[MyColumn1])
)
)
I need the slicer filter (on MyColumn2) to apply before the DAX Filter (MyColumn3) applies. Otherwise the results are very different. How can I make it happen?
Solved! Go to Solution.
Eric,
I figured out this issue though the solution was surprising to me. First of all I was trying to create and use a calculated column like this instead (which is a variation of the previous one):
MyColumn 4 = CALCULATE(COUNTROWS(
FILTER(ALLEXCEPT('MyTable' , 'MyTable'[MyColumn2]
'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= earlier('MyTable'[MyColumn1])
)
)
That did not work. However, it worked when I created and used a calculate measure instead like this:
MyMeasure 4 = CALCULATE(COUNTROWS(
FILTER(ALLEXCEPT('MyTable' , 'MyTable'[MyColumn2]
'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= MAX('MyTable'[MyColumn1])
)
)
Still cannot understand why a measure seems to have the filters applied in a different sequence from a column. Basically, I was trying to use a slicer to display filtered cummulate values in a bar chart.
Any idea when other forms of slicers will be available in Power BI ( like drop down menu, multiple selection, radio button, etc)? Will really help make more versatile slicing and dicing of visualizations
I guess that you're looking for something like
MyColumn 4 = COUNTROWS ( FILTER ( 'MyTable', 'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= EARLIER ( 'MyTable'[MyColumn1] ) && MyTable[MyColumn2] = EARLIER ( 'MyTable'[MyColumn2] ) ) )
If it is not the case, please be more specific on the expected output.
Eric,
I figured out this issue though the solution was surprising to me. First of all I was trying to create and use a calculated column like this instead (which is a variation of the previous one):
MyColumn 4 = CALCULATE(COUNTROWS(
FILTER(ALLEXCEPT('MyTable' , 'MyTable'[MyColumn2]
'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= earlier('MyTable'[MyColumn1])
)
)
That did not work. However, it worked when I created and used a calculate measure instead like this:
MyMeasure 4 = CALCULATE(COUNTROWS(
FILTER(ALLEXCEPT('MyTable' , 'MyTable'[MyColumn2]
'MyTable'[MyColumn3] = "X" && 'MyTable'[MyColumn1] <= MAX('MyTable'[MyColumn1])
)
)
Still cannot understand why a measure seems to have the filters applied in a different sequence from a column. Basically, I was trying to use a slicer to display filtered cummulate values in a bar chart.
Any idea when other forms of slicers will be available in Power BI ( like drop down menu, multiple selection, radio button, etc)? Will really help make more versatile slicing and dicing of visualizations
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |