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,
Why this simple measure in a single table doesn't works?
No matter which option in the slicer of the variable "NOMBRE CORTO" y choose, the measure Prueba2 always shows the same number (16138) which is the total number of rows of the table "Códigos x Parada".
The documentation for ALLEXCEPT doesn't says anything about different behaviours of ALLEXCEPT depending on the context of the formula.
Note: The "|" is just my list separator.
Solved! Go to Solution.
Hi,
Thank you all for your replies but the real reason why it doesn't work is as follow:
ALLEXCEPT behaves as described in the documentation only when it's used as a filter argument in CALCULATE, otherwise it would return the table of its first argument without/except the columns in the subsequent arguments.
A way to prove this, is look at the ALL function that behaves the same way: A single ALL returns all the table of its argument, and the ALL as a filter argument in CALCULATE removes the filters on all the columns of the table.
Two completely different behaviors depending on the context of the function.
…DAX and his ambiguities.
Hi,
Thank you all for your replies but the real reason why it doesn't work is as follow:
ALLEXCEPT behaves as described in the documentation only when it's used as a filter argument in CALCULATE, otherwise it would return the table of its first argument without/except the columns in the subsequent arguments.
A way to prove this, is look at the ALL function that behaves the same way: A single ALL returns all the table of its argument, and the ALL as a filter argument in CALCULATE removes the filters on all the columns of the table.
Two completely different behaviors depending on the context of the function.
…DAX and his ambiguities.
It probably does not work because the column you are putting under the function is not filtered DIRECTLY by your filter. Bear in mind that your fact table should have all its column hidden and slicing should be done only through dimensions. Then it'll work but you have to manipulate your dimensions rather than the fact table. ALLEXCEPT takes off DIRECT filters. If there are none, nothing happens.
Best
D
Use simple ALL function to get your desired result.
Calculate(Countrow(table),All(table))
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Hi @juan_pablo
it depends on your data model but try to use
Prueba2 = CALCULATE(COUNTROWS('Códigos x Parada'), ALLEXCEPT('Códigos x Parada', 'Códigos x Parada'[NOMBRE CORTO]))
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |