Displaying Table Fields as Rows in DirectQuery

Hi akim_no , when you are transforming your data using Dataflowgen 2 , the power query editor , you can add a conditional coloumn, the condition:
if Value contains "Yes" then 1
if Value contains "No" then 1
else 0

In your Power BI Report write a measure:

This is also suited for slicer selection and card visuals:

Hope this works.

Hi akim_no ,
The earlier approach was based on a Static values (such as Yes/No). However, to make the solution more flexible, here’s a dynamic approach to calculate the completion rate.
Based on your reference table, I created an unpivoted table named "Post_ETL", where all fields are transformed into rows.

In this structure, the "Value" column can contain multiple types of entries and is no longer limited to specific values like Yes or No.
Measure to calculate completion count

How the measure works:

• It filters only those rows where the Value is not blank
• Then it counts the total number of actual entries present for each record
• This ensures the count dynamically updates based on the underlying data

Measure to calculate completion rate%

For the completion rate:

• Use Actual_Entries as the numerator
• Use (Distinct count of Fields × Distinct count of Records) as the denominator
• Format as Percentage.

This calculation provides the overall completion rate, considering only non-blank entries and dynamically adjusting based on the data and applied filters.

Hope this helps!