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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

-Ozym4nd1az- , You have to take min /max/count/sum etc. If need firstnonblank or lastnonblank

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

-Ozym4nd1az- there are many ways to handle it, one is simpy create a measure with the following expression and use that in your visuals, remove SLA met and SLA not met columns from the visual

 

SLA Met Measure = 
CALCULATE ( COUNTROWS( Table ), Table[SLA Met] = 1 ) )

 

or add a page or visual level filter with a condition where SLA Met = 1

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!