Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Check if row contains the same value

Hi,   Is there a way in Power BI/Dax to check if a row has matching values in two columns (Room & Building Name), and if it does and the total has already been worked out once for that room and bui...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi camargos88 ,

 

Unfortunately, its bookings data so the room and building will always have duplications as theres multiple bookings for that room.

 

Thanks

 

Liam

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

How are you calculation the total for each combination ?

Can you explain your model ?

 

Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi camargos88 ,

     

    I currently have the measure of:

     

    Total Bookable Hours = CALCULATE(

        COUNT(vwDimDate[Date]),

        FILTER(vwDimDate,vwDimDate[WorkingDayFlag]=1)) * 10

     

    This however, doesn't take into consideration that a room could be duplicated for its bookable hours.

    Does that make sense?

     

    Thanks

     

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous ,

       

      I would try to rank the values using Power Query and test if it's the number 1 to assign the value..

       

      Ricardo