Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a table which has data as below:
I am trying to find the distinct count of account_nos for passed and failed records. I created three measures
Failed Records:
m_incomplete records = calculate(distinctcount(ifcs_account_no),dq_issue="in-complete")
Total Records:
m_total_records = calculate(distinctcount(ifcs_account_no),dq_issue="record_set")
Passed Records:
m_completed_records = totalrecords - failedrecords
Now, when I want to show only the passed records in the table. I add the passedrecords in the filter to restrict to only "1" as shown in the image. I get some extra records. Expected output is 4952 but I get 4960
Output after removing filter:
I noticed that some of the records are not showing right values. examples below:
the orange highlighted ones should be 0 for complete_records(passed) and should be 1 for in-complete records(failed) but I am getting opposite values.
Could someone please assist here.
Please note that: when I only have ifcs_account_no in the table, then I am getting correct results, I get incorrect values when I drag additional fields
Could someone please assist here.
Hi @poojithas ,
Pls share your sample pbix file ,and remember to remove confidential data.
Best Regards
Lucien
@v-luwang-msft I do not see attchment option to include pbix file in here. Could you pls let me know how I can send
@v-luwang-msft
Please find the report here Report
The "Passed Records" page shows 5 records , but the expected output is 2 records
(ifcs_account_no: 200145442 and 200152405)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.