Forum Discussion
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 | 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 |
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.
4 Replies
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.
this is perfect
thank you for your help I appreciate
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
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
