Forum Discussion

haniizz's avatar
haniizz
Icon for Helper II rankHelper II
2 years ago
Solved

Help with unique values

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    haniizz
    Icon for Helper II rankHelper II
    2 years ago

    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