Forum Discussion

haniizz's avatar
haniizz
Helper 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 ,

 

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

    this is perfect

    thank you for your help I appreciate