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 all,
I need a measure where "Consolidate" and "defer" only shows up at the customer name level and not on the sale order drill down as it is doing currently (highlighted below). I would like the "defers" in the below example to be blank.
Any help would be appreciated.
Thanks,
Brian
Solved! Go to Solution.
Try using ISINSCOPE with the Sales Order No column and put your measure in the false condition (blank() if true).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@airwolf39 , isinscope can help
if(isinscope (Table[Customer_name]), [Model recommendation], blank())
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
I have never used isinscope before, but it appears to be working in a way that i would not expect. For some reason the formula shows that my sales order #s are inscope of the customer name and so the forumla doesnt work:
Try using ISINSCOPE with the Sales Order No column and put your measure in the false condition (blank() if true).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |