- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
do not apply a filter on the total
hello , i really need help
so i create a measure 1
Chiffre_d'affaire_encaissé = [ttc_actuel]-Finance[SoldeRisque]
after that , i add another measure 2 to display only the positive amount and change those how are negatif to 0
CA_Encaissé_filtré = SWITCH(TRUE(); ([Chiffre_d'affaire_encaissé] < 0) ; 0 ; [Chiffre_d'affaire_encaissé])
My problem is that in the total it's apply this condition too and i want to display the total
any idea please haw to disable this filter on the total
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
You can also take a look at my Matrix Measure Total Triple Threat Rock & Roll Quick Measure here:
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you for your response but i'm sorry but i didn't find my solution in this you work with average per cqtegory and for my case i want to apply this filter only on rows et display the total without taking in consideration this filter on total 😕
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Right, it's a general solution that you need to modify to fit your specific use case.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i khnow , but in my case i didn't find how to remove the filter from the total 😕

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-02-2024 06:12 AM | |||
05-11-2024 12:00 AM | |||
08-22-2024 07:04 AM | |||
09-27-2024 04:19 AM | |||
09-18-2024 03:32 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |