Dax function help

Tarun_B9012 — Wed, 23 Oct 2024 12:31:30 GMT

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.

Re: Dax function help

Anonymous — Thu, 24 Oct 2024 01:15:17 GMT

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

topic Re: Dax function help in DAX Commands and Tips

Dax function help

Re: Dax function help