Just adjust the formula with FILTER Function as below:
Parent E-Incidents = CALCULATE ( [Total Events DM], FILTER ( DM_Fact_Incident, DM_Fact_Incident[Parent Incident] <> BLANK () && ( DM_Fact_Incident_calc[pIncidentType] = "Incident" || DM_Fact_Incident_calc[pIncidentType] = "Security Incident" || DM_Fact_Incident_calc[pIncidentType] = "Request For Standard Change" ) && DM_Fact_Incident[Parent Emergency] = TRUE ) )
Here is an exampl eof how the table could look:
|145||Request For Information|
So I want to distinct count all rows which has "Incident", "Request For Standard Change' or "Security Incident" in the pIncidentType column, but NOT when the Parent Incident Row is null
And the output should be 3 rows the 2 rows of 123 should count as 1, And then the last two rows should also count
Hope that makes it easier
@VegarOyfoss - Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.