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.
Hello All,
following situation:
We have a table like
ProductCategory | Product
A | A1
A | A2
A | A3
B | B1
B | B2
Now I want to show only ProductCategory where Count(Product) > 2, e.g. ProductCategory A
Is there any chance to do this in DirectQuery Mode (and not to use Power Query Editor)
I could think of possible solutions in Import Mode (e.g. New Column with Calculate etc) but in DirectQuery?
Thanks and Best Regards
Solved! Go to Solution.
Hi @Anonymous ,
There isn't any context in the Page or Report Level filters. So we can't use a measure there. There is a workaround. You can add a new table like below and use a measure instead. Please refer to the snapshot below.
1. A new table.
N
1 |
2 |
3 |
2. Create a measure.
Measure = VAR countProduct = COUNT ( directquery[Product] ) RETURN IF ( countProduct > MIN ( Table1[N] ), countProduct, BLANK () )
3. Add the new column in a Page or Report filter.
Best Regards,
Hi,
This measure should work
Measure1 = if(COUNTROWS(Data)>2,COUNTROWS(Data),BLANK())
Hope this helps.
HI @v-jiascu-msft ,
very interesting solution. It works but produces a huge join (if used with a real table), which results in the 1Mio Row Problem (Thought this would only relate to the result set shown, but seems to make problems if the join result is > 1 Mio. even in the background)
@Ashish_MathurI Can not use this in a Report or Page Filter.
Thanks for your help.
Best Regards
Hi,
thanks for your response.
Tthis is possible in Visual Level Filter only.
I am looking for a solution for Page or Report Level.
Best regards
Hi @Anonymous ,
There isn't any context in the Page or Report Level filters. So we can't use a measure there. There is a workaround. You can add a new table like below and use a measure instead. Please refer to the snapshot below.
1. A new table.
N
1 |
2 |
3 |
2. Create a measure.
Measure = VAR countProduct = COUNT ( directquery[Product] ) RETURN IF ( countProduct > MIN ( Table1[N] ), countProduct, BLANK () )
3. Add the new column in a Page or Report filter.
Best Regards,
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |