Forum Discussion
scoutmedic
Helper I
Helper ICalculated Threshold By Production and Error
Good afternoon, I'm new to PBI and developing reports for my organization. I've taken some basics courses and searched the forum, but I'm stumped. I'm trying to create a calculated threshold line on ...
you will want to expand your data model a bit.
and then you can use TREATAS to lookup the thresholds.
And compare against the actual error rate
lbendlin
Super User
Super Useryou will want to expand your data model a bit.
and then you can use TREATAS to lookup the thresholds.
And compare against the actual error rate
scoutmedicHelper I
Helper IThat worked great! I was able to create a combo chart and add the Acutal field to the secondary Y-axis to show number vs actual allowed.
It took me a while (and some internet searching) to figure out how not to summarize the Threshold and Actual columns. The trick was creating them as measures, not columns.