Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 | IsDefault | IsActive | CompanyId |
F Electric | Husker | False | 11 | |
F Electric | General Service | True | True | |
F Electric | General Service | True | True | |
F Electric | Glacial Energy | False | True | 12 |
F Electric | Irrigation | True | True | |
F Electric | Irrigation | True | True | |
F Electric | Large Commercial | True | True | |
F Electric | Large Commercial | True | True | |
F Electric | Large Commercial Load Control | True | True | |
F Electric | Large Commercial Load Control | True | True | |
F Electric | Residential & Small Business | True | True | |
F Electric | Residential & Small Business | True | True |
I want to count the number of distinct names in the 'RateSchedule - Current'[RateScheduleName]
Here is the formula I tried to use:
Solved! Go to Solution.
@rweb95 , Try measure as
calculate(DISTINCTCOUNT('RateSchedule - Current'[RateScheduleName]), filter('RateSchedule - Current', 'RateSchedule - Current'[IsActive] && 'RateSchedule - Current'[IsDefault]
&& isblank('RateSchedule - Current'[CompanyId])))
Hi,
Does this work?
=calculate(DISTINCTCOUNT('RateSchedule - Current'[RateScheduleName]), RateSchedule - Current'[IsActive]=TRUE(),'RateSchedule - Current'[IsDefault]=TRUE(),'RateSchedule - Current'[CompanyId]=BLANK())
@rweb95 , Try measure as
calculate(DISTINCTCOUNT('RateSchedule - Current'[RateScheduleName]), filter('RateSchedule - Current', 'RateSchedule - Current'[IsActive] && 'RateSchedule - Current'[IsDefault]
&& isblank('RateSchedule - Current'[CompanyId])))
Wonderful! It did work. Thank you for your help!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |