Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to buid a matrix with data from a project.
However, i have an issue with the status column. When I go to a upper level, the consolidation is brinding "Done" as it is the latest value, but actually should be late...as we have an acitivity late.
Is there a way to fix it or to bringing blank when it is a upper level?
Thank you!!!!!!
Solved! Go to Solution.
Hi Diasmt2,
Try creating a DAX measure like:
Status =
SWITCH (
TRUE(),
ISINSCOPE ( Table1[Lower Level] ), SELECTEDVALUE ( Table1[Status] ),
ISINSCOPE ( Table1[Upper Level] ), IF ( "Late" IN VALUES ( Table1[Status] ), "Late", "Done" )
)
Of course, please use your actual table and column names instead of my placeholders, and incorporate your own logic into the last line. The main thing I'm trying to show is the SWITCH/ISINSCOPE measure structure, which allows you to have different logic at different levels of detail in your hierarchy.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Hi Diasmt2,
Try creating a DAX measure like:
Status =
SWITCH (
TRUE(),
ISINSCOPE ( Table1[Lower Level] ), SELECTEDVALUE ( Table1[Status] ),
ISINSCOPE ( Table1[Upper Level] ), IF ( "Late" IN VALUES ( Table1[Status] ), "Late", "Done" )
)
Of course, please use your actual table and column names instead of my placeholders, and incorporate your own logic into the last line. The main thing I'm trying to show is the SWITCH/ISINSCOPE measure structure, which allows you to have different logic at different levels of detail in your hierarchy.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |