Calculated column taking a count fixed to a country column
I would like to make a column or measure which takes my country column and return a number of houses in a certain colour. For instance I have 23 yellow houses in my dataset in US and 14 yellow houses in Poland A: Country column (e.g. Poland, United States) B: Colour of house (e.g. Red, Yellow) My wish i to get this out: COUNTRY (Count of yellow houses) United States (23) Poland (14) In tableau I would use a count and a FIX logic, i wonder if powerBI is able to make counts fixed to a specific country i a column
