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
working out product availability. the parts can have multiple components
is there a way to give a partial fail if just one component fails?
components are worked out in a table using calculated column, i would like to do a graph showing just the parent part and if the sum of components is ok or fail
example part below and headers from table
Solved! Go to Solution.
@djwbaker , Not very clear.But you need like
if(isblank(calculate(count(Table[purhase_part]), filter(Table, Table[Part] ="fail"), allexcept(Table, Table[ord_part])) ) ,"OK", "Fail")
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@djwbaker , Not very clear.But you need like
if(isblank(calculate(count(Table[purhase_part]), filter(Table, Table[Part] ="fail"), allexcept(Table, Table[ord_part])) ) ,"OK", "Fail")
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak i am using slicers in my report how can i adapt the measure to work?
tried allselected instead of allexcept but it fails
many thanks
worked perfectly thank you
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |