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.
I can't seem to understand how to get the right filter context to apply the selected two slicers to the measure in the visual. I think I need to use the ALLSELECTED and RELATED to get the measure to only have the two slicer filters rows.
Here's what I have before I add the measure to the visual, with the two slicers selected:
and then I get all the rows (parts) when I add in my measure that shows a 1 for parts with SumNetSold > 0 else 0.
(can't attach the pbix, I'll try and load and link it)
https://drive.google.com/file/d/1mSwTTSFh6AReP07DuhcH93GwlA5OmvsL/view?usp=sharing
Hope this link works
Thank you all for any help
Solved! Go to Solution.
Usually that is done through the data model. Note that RELATED only applies to calculated columns.
Hi,
I do not know what result you want but does this measure work?
NoDemand = IF (
[SumNetSold] > 0,
1,
BLANK()
)
Usually that is done through the data model. Note that RELATED only applies to calculated columns.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |