Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys!
I need a lot of help with the following:
In an matrix, I put the priority as a criterion and the rankings as follows in the image:
In this case, there is also a priority "Critical", but depending on what was filtered in "Final Group", this priority does not appear as it has no value.
I would like to know if it is possible to make it so that even having no value, it is possible to show the priority "Critical" with a value of zero.
I don't know if I made myself clear, I tried to explain as best I could!
Thanks for your attention in advance.
Solved! Go to Solution.
Hi @avitoriasrocha !
Try an if condition like:
IF(
value = BLANK(),
0,
value
)
Let me know if that helps!
You can try the following measure:
Show 0 if critical =
IF (
SELECTEDVALUE ( 'Priority Table'[Priority] ) = "Critical",
COALESCE ( [Your measure], 0 ),
[Your measure]
)
Proud to be a Super User!
Paul on Linkedin.
I'm answering from my phone so I'll do my best to explain without screenshots.
One way to do it...
Let me know if that helps.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @avitoriasrocha !
Try an if condition like:
IF(
value = BLANK(),
0,
value
)
Let me know if that helps!
I found an even simpler solution here
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |