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.
Hello Experts,
In my dashboard I am calculating Cpk values for different charactertsic.
Formula I use is as below:
Solved! Go to Solution.
Hi @nehajadhav166 ,
You cannot put the defined variables into the min function.
It only supports column or expressions.
You can split the two variables, create separate measures for them to be calculated, and then use the min function to compare them.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @nehajadhav166 ,
You cannot put the defined variables into the min function.
It only supports column or expressions.
You can split the two variables, create separate measures for them to be calculated, and then use the min function to compare them.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Process[LimitLower]/Process[LimitUpper] both are columns in table.
Do I have to still change and create measure for this?
Thanks,
Neha
Hi @nehajadhav166 ,
If you want to give calculations for them, it is necessary to create MEASURES.
What I mean is that you can split the process of finding the value of these two into two MEASURES
One measure to calculate Cplower and the other to calculate Cpupper. And then create the third measure to compare the two value.
Please let me know if you have any further questions,thanks in advance~
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
My issue is resolved now. There was data discrepency while loading data using power query editor.
I am still using same formula with single mesaure and it works fine for me.
Thanks,
Neha
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 |
---|---|
108 | |
105 | |
86 | |
74 | |
66 |
User | Count |
---|---|
123 | |
112 | |
96 | |
82 | |
72 |