Dax function help

[Tarun_B9012]

I have calcualted columns with the values 1 and 0, I want to create a gauge viz with the percentage of Yes and no. 

The calculcation for % of Yes and no is as follows: 

Collab with static counts/Ack_flag with "yes"*100

calculated column for Collab with static counts is as follows:  

Collab with static counts = If('DSI Commit Metric'[cfg_ww_dsi_flag]="red" &&

'DSI Commit Metric'[part_ww_dsi_flag]="Red" &&

'DSI Commit Metric'[commit_status]="static",1,0)

calculation for Ack_flag which has yes, depends on three other columns to be yes. 

If('DSI Commit Metric'[cfg_ww_dsi_flag]="red" &&

'DSI Commit Metric'[part_ww_dsi_flag]="Red" &&

 'DSI Commit Metric'[commit_status]="static" ,1,0)

How to get to the numbers in percentage? 

Please feel let me know if you need more information. 

[v-heq-msft]

Hi @Tarun_B9012 ,

Based on your description, it seems that you are trying to determine if a row of data is compliant based on different column conditions. The dax expression you provided only shows you the process of determining your static indicator. It does not show the logic of how you assign the YES. Can you provide sample data and expected results so we can help you faster? Please hide sensitive information in advance

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best regards,
Albert He