Forum Discussion

CLQ's avatar
CLQ
Icon for Helper I rankHelper I
3 years ago
Solved

Get the repeated values ​​in a table, using, if possible, calculatedtable

Hello everyone. I have the following table (Table1): Name Order Date  Day Month Store Jhon 2022/06/01 1 6 TV Jhon 2022/06/01 1 6 TV Jhon 2022/07/01 1 7 TV Kelly...
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi CLQ ,

     

    You can try this method:

    Result =
VAR _table =
    FILTER (
        'Table',
        AND ( 'Table'[Month] = 6, 'Table'[Store] = "TV" || 'Table'[Store] = "Xbox" )
    )
VAR _table1 =
    GROUPBY ( _table, [Name], "num", COUNTX ( CURRENTGROUP (), [Name] ) )
RETURN
    SUMMARIZE ( FILTER ( _table1, [num] > 1 ), [Name] )

    The result is:

    Hope this helps you.

    Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

CLQ Try:

Table = 
  VAR __Table = GROUBY(FILTER('Table',[Store] <> "Phone" && [Month] = 6),[Name],"__Count",COUNTX(CURRENTGROUP(),[Order Date]))
  VAR __Result = FILTER(__Table,[__Count] > 1)
RETURN
  __Result