Count of Distinct When Two Conditions met

[cm]

Friends,

See the attached Excel -  super small representation of my data. My task is to get a COUNT of DISTINCT report #s (Column A), filtered by category (Column B) and Topic (Column C).

For example, using the attached, I'm trying to get a count of unique report #s in category A on topic X. Answer should be 3.
Please help. I'm so novice.

Thanks.

[OmarBenSalem]

Use a bar chart, or a pivot table or a table or any chart u want:

as dimension :

1)Category

2) Topic

a measure:

count(distinct Report)

[cm]

THanks! What would the expression look like in set analysis?

[kaanerisen · Accepted solution]

Hi,

Expression should be like:

count({<CATEGORY={'A'},TOPIC={'X'}>}distinct REPORT)

Hope it helps..