Forum Discussion
Show Only Matching Values
Hi Can someone help me on how to create a measure or m-code in showing only values that matched the Invoice Number for the fak column and don't display the rest? //NT
Hi,
You can create a measure as below by replacing with your columns:
Matches = IF(CALCULATE(SUM('Table'[A]))=CALCULATE(SUM('Table'[Invoice])),1,0)
Then, put the measure into the filter pane of the table visual and have it set to 1