Check if row contains the same value

Question

Hi,&nbsp;Is there a way in Power BI/Dax to check if a row has matching values in two columns (Room &amp; Building Name), and if it does and the total has already been worked out once for that room and building (1280). then enter 0 like in my example below?&nbsp;RoomBuilding NameHours available (No Duplicates)Classroom 1Building 11280Classroom 2Building 21280Classroom 2Building 20Classroom 2Building 20Classroom 4Building 41280Classroom 4Building 40

camargos88 · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Is it possible to have a table without duplicated data and 1 column to identify the qtd os duplicated ?So you can avoid it.&nbsp;Ricardo

anonymous · Answer

hi&nbsp;camargos88&nbsp;,&nbsp;Unfortunately, its bookings data so the room and building will always have duplications as theres multiple bookings for that room.&nbsp;Thanks&nbsp;Liam

camargos88 · Answer

Anonymous&nbsp;&nbsp;How are you calculation the total for each combination ?Can you explain your model ?&nbsp;Ricardo

anonymous · Answer

Hi&nbsp;camargos88&nbsp;,&nbsp;I currently have the measure of:&nbsp;Total Bookable Hours = CALCULATE(&nbsp;&nbsp;&nbsp; COUNT(vwDimDate[Date]),&nbsp;&nbsp;&nbsp; FILTER(vwDimDate,vwDimDate[WorkingDayFlag]=1)) * 10&nbsp;This however, doesn't take into consideration that a room could be duplicated for its bookable hours.Does that make sense?&nbsp;Thanks&nbsp;

camargos88 · Answer

Anonymous&nbsp;,&nbsp;I would try to rank the values using Power Query and test if it's the number 1 to assign the value..&nbsp;Ricardo

Forum Discussion

Check if row contains the same value

7 Replies

Related content

Check column for similar values

check if value contains in another table

Check if column contains ONLY specified value

Check if string contains certain characters

Contain Word

Room	Building Name	Hours available (No Duplicates)
Classroom 1	Building 1	1280
Classroom 2	Building 2	1280
Classroom 2	Building 2	0
Classroom 2	Building 2	0
Classroom 4	Building 4	1280
Classroom 4	Building 4	0