Forum Discussion

-Ozym4nd1az-'s avatar
-Ozym4nd1az-
Icon for Helper I rankHelper I
6 years ago
Solved

Power BI distinct values for column for table creation

I am trying to perform a deletion of a row that is duplicated in Powerbi visuals. I cannot use Power Query here. So, I must delete the row with duplicated values for the columns values of Monthly dat...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi -Ozym4nd1az- ,

     

    I see. So you should use DISTINCT() function to create a distinct table and use this table to create a visual.

    Then create a measure as below and add it to visual level filter.

    Measure = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[number]))=1,1,IF(SELECTEDVALUE('Table'[SLA not met])=1,0,1))

    Or if you want a table, you can create a calculated column on the raw table as below.

    Column = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[number]))=1,1,IF('Table'[SLA not met]=1,0,1))

    Then do the distinct work.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

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

DR_GT's avatar
DR_GT
New Member
6 years ago

Hello -Ozym4nd1az- I understand that you need to do a group by by date and number of records that complied with the SLA, it can work something like this:

NewTable =
SUMMARIZE (
    ALL ( Table[Monthly Date] );
    Table[Monthly Date];
    "Count"; SUM ( Table[SLA met] )
)

In essence, that logic can go on.