Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I need your help, I don't find solution alone.
I would like identify by ID, #ID where I have only one row with a critea at "Entree_SVI" (see example, results attended is in red).
How I can filter on row?
Table: DATA SVI_2
Colums:
- InboundCallVoice_CallId
- FilterId
Example:
EI228-C21872 | Platinum |
EI228-C21872 | Entree_SVI |
EI228-C22096 | Platinum |
EI228-C22096 | Entree_SVI |
EI228-C22467 | Platinum |
EI228-C22467 | Platinum_Renvoi |
EI228-C22467 | Platinum_Transf |
EI228-C22467 | Entree_SVI |
EI228-C22880 | Platinum |
EI228-C22880 | Entree_SVI |
EI228-C22880 | Entree_Ferm |
EI228-C22880 | Platinum_Ferm |
EI228-C23484 | Entree_SVI |
EI228-C23485 | Entree_SVI |
EI228-C23486 | Entree_SVI |
Solved! Go to Solution.
Hi @aymeric_kolan,
Please use below DAX formula to create a calculated table which only returns three rows that are highlighted in red.
Table_1 = CALCULATETABLE ( 'DATA SVI_2', FILTER ( 'DATA SVI_2', CALCULATE ( COUNT ( 'DATA SVI_2'[FilterId] ), ALLEXCEPT ( 'DATA SVI_2', 'DATA SVI_2'[FilterId] ) ) = 1 && 'DATA SVI_2'[InboundCallVoice_CallId] = "Entree_SVI" ) )
Best regards,
Yuliana Gu
Measure = IF(CALCULATE(COUNT([InboundCallVoice_CallId]),FILTER('DATA SVI_2',[FilterId]="Entree_SVI")),1,0)
Hi smoupre.
Thanks but when I used code , it showed "1"
But I would like "3" with my example because there is only 3 ID where there is only one row with "Entree_SVI"
Mesure = IF(CALCULATE(COUNT('DATA SVI_2'[InboundVoiceCalls_CallId]);FILTER('DATA SVI_2';[FilterId]="Entree_SVI"));1;0)
Turn it into a column and just SUM the column.
Thank you for your time but request doesn't return answer I need.
I need to know how many ID I have with only one row "Entree_SVI".
When one ID had more than one row, I don't need to count it.
Hi @aymeric_kolan,
Please use below DAX formula to create a calculated table which only returns three rows that are highlighted in red.
Table_1 = CALCULATETABLE ( 'DATA SVI_2', FILTER ( 'DATA SVI_2', CALCULATE ( COUNT ( 'DATA SVI_2'[FilterId] ), ALLEXCEPT ( 'DATA SVI_2', 'DATA SVI_2'[FilterId] ) ) = 1 && 'DATA SVI_2'[InboundCallVoice_CallId] = "Entree_SVI" ) )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |