column in calculate
1 Topic
How to use a dataset Column without aggregation in a calculate function
Hi All, I have 2 datasets - Logs: Path Hits Month_Num Master File: Country Dept Path Relationship - MasterFile(Path) to Logs(path) 1:M relationship I have to create a measure that will give the count of reports whose hits is less than 10 - by dept & country, based on the month filter. I have tried to take calculate(sum(hits), path = _path) but for this the var _path needs to be defined using aggregate function in the measure which doesn't work as expected. I have to build a dax for the below sql - select country, dept, count(report) from (select country, dept, path, sum(hits) from <tables> where month in <selected filter values> group by country, dept, report having sum(hits) > 0 and sum(hits) < 10 and sum(hits) is not null) group by country,dept I am stuck with this for some time now, appreciate any help to solve this issue. Thanks in advanceSolved2.5KViews0likes11Comments