Forum Discussion

Rahulty's avatar
Rahulty
New Member
1 year ago
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 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.

Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.