DAX Measure

[prashantg364]

I am having data as per the below table.

I want to calculate distinct cluster counts against each KPI in each band.

like

Measure 1- Distinct cluster count against each KPI in 700 band

Measure 2 - Distinct cluster count against each KPI in 3500 band

Measure 3 - Distinct cluster count against each KPI in both 3500 & 700 band as one 

Pls help me with measure.

Circle	Cluster	Band	17_KPIs
BR	BR-ARRH-0001	700	12
BR	BR-ARRH-0001	3500	15
BR	BR-ARRH-0002	700	15
BR	BR-ARRH-0002	3500	15
BR	BR-BGLP-0004	700	15
BR	BR-BGLP-0004	3500	14
BR	BR-ARRE-0001	700	15
BR	BR-ARRE-0001	3500	15
BR	BR-ARRH-0010	700	15
BR	BR-BGLP-0013	3500	10
BR	BR-BGLP-0014	700	15
BR	BR-BGLP-0004	3500	16

[some_bih]

Hi @prashantg364  please try  measures below
Did I answer your question? Mark my post as a solution! Kudos Appreciated!

DistinctClusterCount 700 =
CALCULATE(
DISTINCTCOUNT(<Your table name>[Cluster]),
<Your table name>[Band] = 700
)

DistinctClusterCount 3500 =
CALCULATE(
DISTINCTCOUNT(<Your table name>[Cluster]),
<Your table name>[Band] = 3500
)
DistinctClusterCount BothBands =
VAR _Clusters_700 = CALCULATETABLE(
VALUES(<Your table name>[Cluster]),
<Your table name>[Band] = 700
)
VAR _Clusters_3500 = CALCULATETABLE(
VALUES(<Your table name>[Cluster]),
<Your table name>[Band] = 3500
)
VAR Clusters_BothBands = UNION(_Clusters_700, _Clusters_3500)
RETURN
COUNTROWS(Clusters_BothBands)

[prashantg364]

Not working,

while calculating unique cluster both bands data is resulting, not the unique cluster count passed in both bands.