Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I want to calculate Disticnct count of Column1 based on Column2. I added a Measure Column
DISTINCTENV = DISTINCTCOUNT(Sheet1[Environment]) which gives below output.
Original Table:
Date | Exterprise | Environment | Application |
Mar-17 | ANBC | DV1 | APP1 |
Mar-17 | ANBC | DV1 | APP2 |
Mar-17 | ANBC | DV2 | APP3 |
Mar-17 | ANBC | DV2 | APP4 |
Mar-17 | ANBC | DV2 | APP5 |
Mar-17 | ANBC | DV2 | APP6 |
Mar-17 | ANBC | DV3 | APP7 |
Mar-17 | CNBC | DV1 | APP8 |
Mar-17 | CNBC | DV2 | APP9 |
Mar-17 | CNBC | DV3 | APP10 |
Table after adding MEasure. But Total is coming 3. It should be 6. How can Count Sum of Measure column?
Enterprise | Measure |
ANBC | 3 |
CNBC | 3 |
Total | 3 |
Solved! Go to Solution.
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
Hi, try with this:
DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))
Thanks this helped.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |