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,
I have the following measure:
Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ),
FILTER (
ALL ( GrootboekRekening[GrootboekCategorieCodeNiveau2] ),
GrootboekRekening[GrootboekCategorieCodeNiveau2] = " 05"
)
)
I have a page with a filter on Debiteurcode is not 998.
I want that page filter not to be applied to the above measure. I have tried with ALL(debiteurcode) and ALLEXCEPT, but I can't get it to work. Any help is very much appreciated. Thank you!
Solved! Go to Solution.
I figured it out!
Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ), REMOVEFILTERS(Debiteur[DebiteurCode]),
filter(GrootboekCategorieNiveau2, GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2] = "Voorraden"))
Sorry, it is Debiteur[DebiteurCode]
You can try to CROSSFILTER the relationship with Debiteur table to NONE
Hi, that didn't work unfortunately.
@JoyceW
Yes it won't. Actually the tablr supplied to the visual is prefiltered by the page filter even crossfiltering the relation to non won't restore the rows filtered out by the page filter. I don't know of any method that can do that but I hope others will.
I figured it out!
Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ), REMOVEFILTERS(Debiteur[DebiteurCode]),
filter(GrootboekCategorieNiveau2, GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2] = "Voorraden"))
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 |