Forum Discussion

MichaelH78's avatar
MichaelH78
Frequent Visitor
2 years ago
Solved

Measure that counts in second column

Hi, I have a table with three columns: - Person number - Primary residence (city) - Secondary residence (city) Person number Primary residence (city) Secondary residence (city) 1 City 1 ...
  • MichaelH78's avatar
    MichaelH78
    2 years ago

    I have solved it simply: With an additional column in data, which calculates the number per primary residence location, but in primary and secondary residence. This means that all rows with the same location always contain the same value.
    The measure then only needs to add a MAX (or MIN or AVG) to the new column 😉

MichaelH78's avatar
MichaelH78
Frequent Visitor
2 years ago

Hi Wisdom Wu,

hi, thanks for your help. This looks very good and also works in Power BI.
Before I transfer everything to Power BI: Does this also work in Excel? Power Pivot in Excel does not recognise SELECTEDVALUE. You can probably do something with HASONEVALUE, but I can't manage that 😉

Best regards

Michael

MichaelH78's avatar
MichaelH78
Frequent Visitor
2 years ago

I have solved it simply: With an additional column in data, which calculates the number per primary residence location, but in primary and secondary residence. This means that all rows with the same location always contain the same value.
The measure then only needs to add a MAX (or MIN or AVG) to the new column 😉