Counting values with unique filter as filter argument

[toddpbi]

Hello Power BI community,

Here is what my current data looks like in Power BI.

ID         Solution
1           Solved
1           Solved
2           Not Solved

2           Not Solved
3           Solved
4           Solved

I am trying to create a measure which counts the amount of solved transactions for a unique ID value.
Currently, I am using the following measure:

Number of Resolutions = CALCULATE(Countrows('FACT-CallTable'), 'FACT-CallTable'[Solved]="Solved", ???))

Is there a particular filter argument I can use within this formula to ensure the count of solution is not double counted?

Regards,

[toddpbi · Accepted solution]

Number of Resolutions = COUNTAX(VALUES('FACT-CallTable'[Column]), CALCULATE(COUNT(:Table"[Column]), 'Table'[Column] = "true"))

Solved with the following formula thanks to a reference in another post. If anyone has any other methods please let me know. 🙂

[v-yuezhe-msft · Accepted solution]

@toddpbi,

Create  a measure using DAX as below.

Number of Resolutions = CALCULATE(DISTINCTCOUNT('FACT-CallTable'[ID]), FILTER('FACT-CallTable','FACT-CallTable'[Solution]="Solved"))




Regards,
Lydia

[toddpbi]

Thanks Lydia,

Worked a charm. My formula above also works too. Sorry for the simple question.

[toddpbi · Accepted solution]

Number of Resolutions = COUNTAX(VALUES('FACT-CallTable'[Column]), CALCULATE(COUNT(:Table"[Column]), 'Table'[Column] = "true"))

Solved with the following formula thanks to a reference in another post. If anyone has any other methods please let me know. 🙂