Distinctcount linked to another column

Hi,

You should drag speciality to the X axis of the Graph and then drag the Distinctcount measure to the value section.  Anyways, if you want to write a formula, write this measure:

=CALCULATE(DISTINCTCOUNT(Data[Date of operation]),Data[Speciality]="XXX")

Replace XXX with the specific speciality.

Hi phaum1967

“have a distinctcount on date in order to count all different dates for each speciality”

To achieve requirement above, create a column

Column = CALCULATE(DISTINCTCOUNT(Sheet1[Date of operation]),ALLEXCEPT(Sheet1,Sheet1[Speciality]))

Best Regards

Maggie