Drill thought not giving correct result on using measure in table

[Mattkarim9908]

I am facing issue wherein I have 2 measures.

1. Measure 1 calculate the count of response where the followup has not done within 1 hr
2. Measure 2 calculate the count of response where the followup has not done on same day.

Though both the measures are being calculated from same table, I have kept the measures in diff tables to distinguish between the measures and fact table.

Now while I am trying to drillthough for  Measure 1, the drillthrough is working fine and no issue seems to be appeared, However as long as I check the data for MEasure 2, I find that instead of accurate count for Measure 2, I am getting more result and which ever event don't match with measure 2 has blank value appearing.

In screen shot I selected the Red Response not same day which was showing count of 5, however in the result I got 6 as result, but for Red Response not same day has blank appeared.

I have more measures to put in Table and filter to check the failures, however i can't proceed with inaccurate result.

[v-cazheng-msft]

Hi @Mattkarim9908,

May I know whether your issue has been resolved? If you still have problems on it? Could you please provide some sample data of your tables? And please let me know how you create tables relationships, Measure1 and Measure2 and how you create your visual. Thanks in advance!

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,

Community Support Team _ Caiyun