Counting Blanks in two tables

Question

Hi there,&nbsp;I have two related tables: Service Jobs and Time Confirmation.&nbsp;From those two tables I have created this matrix:My goal is to only have the TC OS = 1 (Time Confirmation) for each name (service jobs).&nbsp;From this total number (amount of service jobs with 1 site visit), I will need to divide it by the total amount of service jobs, to get a %.&nbsp;Does anyone have an answer for this?&nbsp;&nbsp;Thanks!

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Counting Blanks in two tables

1 Reply

Related content

Counting Non-Blank Records

Count Blanks Table

Counting nulls

How to get Count from two different table- Un-match Count Table Record with New Table

How to count blank record and un-blank record using DAX in filter Calculations