Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have tried many different formulas and I cannot seem to come up with the answer on how to do this.
I have 4 Tables:
Relationships:
I have a visual where I list the lines from the Area Table. I am filtering if the Total Failed Widgets = 0 and the Total Produced Widgets is >0. This gives me a list of the perfect lines.
I need a visual and formula that counts how many perfect lines are listed and it needs to change based on the date filters on the visual/page/report.
Please help!
@Anonymous
Have you considered using your measures to create calculated columns and creating a calculation based upon that to allow for your count?If you built them as columns your measure would be something along the lines of CALCULATE(DISTINCTCOUNT(Area Table[Line]), Area Table [Total Failed Widgets] = 0 && Area Table[Total Produced Widget] >= 0)
Proud to be a Super User!
I created 2 columns in the Area Table: Total Failed Widgets and Total Produced Widgets. Then I did the measure as you have below and I receive this error message:
The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.
Could you show your raw data and your expected result? Thaks.
This is a copy of what I currently have with an if statement in Line Active/Pass Testm. The expectation is that the graph should show 5 total for lines that are active (with produced units >0) and pass (with no failed inspections).