Not able to see distinct count by quarter in bar chart but I can see in the table

[Tarun2020]

Hi Team,

I am struggling with the dax with distinct count of a column. it is only showing count of emp. (x axis quarter and y axis distinct count ). but when I am using same measure in table view ot is showing me the distinct count. please help me to understand where I am going wrong.

[PabloDeheza]

Hi there!

The are values that are both in Q1 and Q2, therefore the total will show the distict of Q1+Q2, which in this case is 931.

If what you want is to sum 716+483 then try a measure like this:

SUMX(
    ADDCOLUMNS(
    	VALUES( DateTable[Quarter] ),
    	"@Count", CALCULATE( DISTINCTCOUNT( YourTable[ColumnToCount] ) )
    ),
    [@Count]
)

Let me know if that helps!

[Tarun2020]

Hi,

the above dax is giving me same result as . but I want 931 as count (which is distinct ) but in bar chart. 

[daXtreme]

SUMX(
    VALUES( DateTable[Quarter] ),
    CALCULATE( DISTINCTCOUNT( YourTable[ColumnToCount] ) )
)

This formula does the same thing and very likely faster as it does not have to materialize rows as it does in ADDCOLUMNS. Basically, ADDCOLUMNS should be avoided as much as possible in measures.

[Tarun2020]

Hi,

I want ressult as if the skill name or Varinat chnage w.r.t the quarter then it will show as disntinct and count for the quarter but if the emp no. is same and his skill name and variant is also same as compare to the last quarter then will count him only in last quarter not in current quarter becs nothing has changed. Hope I am able to explain my problem.

Emp No.	Skill Tag Name	Variant	Quarter IND	Unique
9033279	Data Management	Beginner	Q3	Unique
9033279	Data Management	Competent	Q3	Unique
6034397	Tableau Developer	Competent	Q3	Unique
900673125	SQL Developer	Competent	Q3	Unique
81901053	Specialised Accountant - Financial Statement Analysis	Beginner	Q3	Not unique
81901053	Specialised Accountant - Financial Statement Analysis	Beginner	Q3	Not unique
77037625	Specialised Accountant - Reconciliation Expert	Beginner	Q3	Unique
6652207	Appeals & Grievances	Proficient	Q3	not uniuqe
6652207	Appeals & Grievances	Proficient	Q4	not uniuqe
4555227	Appeals & Grievances	Proficient	Q3	Not unique
4555227	Appeals & Grievances	Proficient	Q4	Not unique