Forum Discussion

rweb95's avatar
rweb95
Frequent Visitor
5 years ago
Solved

Column Distinct Count with Several Conditions

Hello everyone!   I need help getting a distinct count of names within a column with several conditions applied. Here is a sample of the data I'm working with:   UtilityName RateScheduleName...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    rweb95 , Try measure as

    calculate(DISTINCTCOUNT('RateSchedule - Current'[RateScheduleName]), filter('RateSchedule - Current', 'RateSchedule - Current'[IsActive] && 'RateSchedule - Current'[IsDefault]
    && isblank('RateSchedule - Current'[CompanyId])))

amitchandak's avatar
amitchandak
Super User
5 years ago

rweb95 , Try measure as

calculate(DISTINCTCOUNT('RateSchedule - Current'[RateScheduleName]), filter('RateSchedule - Current', 'RateSchedule - Current'[IsActive] && 'RateSchedule - Current'[IsDefault]
&& isblank('RateSchedule - Current'[CompanyId])))

  • rweb95's avatar
    rweb95
    Frequent Visitor
    5 years ago

    Wonderful! It did work. Thank you for your help!