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.
I need application measuer which not filtered with slicer. I try below measuer but not work: In Reprot I have one slicer Delinquency and I don't want to filterd with this.
@Anonymous
Try the following formula:
#Measure 4 = CALCULATE(SUM(MLlnput[Payments]), ALL(MLlnput))
@themistoklis
If I used "all" it also not fitter with Date in table view. I want to filter with Date but not Slicer.
@Anonymous
Try this:
#Measure 4 = CALCULATE(SUM(MLlnput[Payments]), ALLEXCEPT(MLlnput, MLlnput[Date]))
@Anonymous
Any chance to share the workspace with us?
I find it very strange because you use ALLEXCEPT
I can't share work space because live data. But if you want I can on Skype and show workspace via share screen.
@Anonymous
Another option is to use Edit Interactions.
Click on the Slicer and then move to Format on the Tab on Top and Edit Interactions.
You can then select tables this slicer can affect and which wont.
The icon to use is the following:
Thanks But problem is this I want use this As tool tip. I can use this Edit intrections option. only measuer will help in my case.
Hi @Anonymous
Did you find a solution ?
I have exactly the same problem as you ...
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |