topic Re: Help with unique values in DAX Commands and Tips

Help with unique values

haniizz — Mon, 12 Feb 2024 08:15:00 GMT

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

Re: Help with unique values

Anonymous — Tue, 13 Feb 2024 01:43:17 GMT

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

Re: Help with unique values

haniizz — Tue, 13 Feb 2024 09:56:25 GMT

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

Re: Help with unique values

Anonymous — Tue, 13 Feb 2024 11:45:56 GMT

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.

Re: Help with unique values

haniizz — Tue, 13 Feb 2024 16:10:50 GMT

this is perfect

thank you for your help I appreciate