Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Everyone,
I am trying to flag duplicate values with the following measure since I need it do work with my page filters:
Solved! Go to Solution.
Hi @sv98917n ,
Filter blank value before count rows, check the formula below.
Column =
VAR countid =
CALCULATE (
COUNTROWS ( FILTER ( 'Table', 'Table'[value] <> BLANK () ) ),
ALLEXCEPT ( 'Table', 'Table'[id] )
)
RETURN
IF ( countid > 1, "yes", "no" )
Best Regards,
Jay
Hi @sv98917n ,
Filter blank value before count rows, check the formula below.
Column =
VAR countid =
CALCULATE (
COUNTROWS ( FILTER ( 'Table', 'Table'[value] <> BLANK () ) ),
ALLEXCEPT ( 'Table', 'Table'[id] )
)
RETURN
IF ( countid > 1, "yes", "no" )
Best Regards,
Jay
@sv98917n , Try like
Critical Segment ID (Y/N) = IF (COUNTROWS ( FILTER ( allselected(Table1), Table1[SEGMENT_ID] = MAX( Table1[SEGMENT_ID] ) ) ) >=2 && not(isblank(Table1[SEGMENT_ID])), "YES", "NO" )
It won't let me use the column [SEGMENT_ID] after the not(isblank at the end. Says that has to be a measure in order to work.
Hi @sv98917n
Try adding ISBLANK() in your formula
IF(ISBLANK(Table1[SEGMENT_ID]), "No"),IF (COUNTROWS ( FILTER ( allselected(Table1), Table1[SEGMENT_ID] = MAX( Table1[SEGMENT_ID] ) ) ) >=2, "YES", "NO" ))
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |