Dax

[Rahulty]

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 which involves "met" and "not met" in vertical format. That file also includes date of audit, supervisor name, audit count etc ..

I want a visualisation wherein chart should show me "not met %" parameters wise.

[Anonymous · Accepted solution]

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.

[Rahulty]

Issue resolved ☺️

[Rahulty]

Thanks buddy it was a great help.