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.
Hi everyone
As I know calculate can replace the original filter context(query context) with its inside filters, but i feel puzzled by this simple case.
Hi @ryan-gao,
In this scenario, you may need to use ALL function to firstly ignore any filters that might have been applied, then replace with a new filter context. The formula below is for your reference.
test = CALCULATE ( CALCULATE ( COUNTROWS ( '表2' ), '表2'[name] = "tv" ), FILTER ( ALL ( '表2' ), '表2'[category="electric"] ) )
Regards
Thanks @v-ljerr-msft
In this scenario, I want the red box of the pivot table to retrun 1,your formula can not do this, but I found the final answer . it is "autoexists" . so if rows and columns of the pivot table came from the same table ,it automaticly remove the nonexist combinations first, no matter how the filter context in calculate defines ,it will always return blank.
hope you can understand my poor english
anyone can help?
thanks in advance
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |