Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone.
On Power BI I make the ratio between 2 measures.
And I would like to apply a filter via a segment (so that the user can change it easily) except that the segment
applies the filter for the 2 dax measures on the ratio while I would like it to apply only to one of the 2 measures.
I know it is possible to assign a segment to only one visualization, but is it possible to assign it to only one dax measure ?
Thank you !!
Solved! Go to Solution.
you would modify "measure2" to remove the filter that is controlled by that slicer (via REMOVEFILTERS).
As you can see, I'm making a curve that corresponds to a measure as a function of time. Except that this measure is a ratio, and I would like that when I filter, the filter only applies to "measure1" and not "measure2"
you would modify "measure2" to remove the filter that is controlled by that slicer (via REMOVEFILTERS).
and it doesn't work
please provide more details
As you can see when I filter, the measure2 changes despite the fact that I added removfilter in the dax code "measure2 = CALCULATE([blabla1], filter(blabla2, blabla2[blabla3] = "blabla4"), REMOVEFILTERS(blabla5[blabla6])"
Indeed blabla5[blabla6], corresponds to "Zone Arcep (Achil)"
I have succeeded!!
errors of inattention... thanks !
what is a segment? Can you show an example?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
217 | |
89 | |
82 | |
66 | |
57 |