Help with unique values

[haniizz]

Hello Community 

I need your kind help , how can I get the unique value to measure the ( number of Cycles ) when I have like this data

Project	cycle	country	Budget	Status
Project1	1	USA	1,000000	Done
Project1	1	India	1,500000	Done
Project1	2	USA	2,500000	Done
Project2	1	USA	1,003000	Done
Project2	2	USA	1,500000	Done
Project2	3	USA	2,000000	Done

[Anonymous · Accepted solution]

Hi  @haniizz ,

You can use the following functions:

Measure 2 =
var _table=
SUMMARIZE(
    ALL('Table'),[Project],[cycle],[country])
return
COUNTX(
    _table,[cycle])

While calculating the data you provided, I noticed a small discrepancy that I would like to share with you, regarding the USA's de-emphasized data that should be equal to 5, and in adding India's data, the sum is 6

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[haniizz]

this is perfect

thank you for your help I appreciate

[Anonymous]

Hi  @haniizz ,

Here are the steps you can follow：

1. Create measure.

Measure =
CALCULATE(
    DISTINCTCOUNT('Table'[cycle]),ALL('Table'))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[haniizz]

thank you dear Liu
in fact this should not be 3 , 
in USA we have 2 cycles in project 1 + 3 cycles in project 2 = 6 unique cycles
in India we have 1 cycle in project 1 = 1 unique project
the total should be 7