Forum Discussion
Solved
Dax
Hi Can anyone help with power bi issue.. I have excel file which I have uploaded to power bi now that is quality parameters and scoring excel sheet. My question is i have 19 quality parameters ...
Hi Rahulty ,
I create a table as you mentioned.
I think you can create a calculated column at first.
Column = IF('Table'[Status]="Not Met",1,0)Measure = DIVIDE(SUM('Table'[Column]),COUNT('Table'[Parameter]),0)Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rahulty ,
I create a table as you mentioned.
I think you can create a calculated column at first.
Column = IF('Table'[Status]="Not Met",1,0)
Measure = DIVIDE(SUM('Table'[Column]),COUNT('Table'[Parameter]),0)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
