Forum Discussion
Helper IIDAX Measure
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 |
2 Replies
- some_bih
Community Champion
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)
prashantg364Not working,
while calculating unique cluster both bands data is resulting, not the unique cluster count passed in both bands.
