Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

GroupBy and Having Clause

Hi,   How do I use the GroupBy and Having clause in my dataset? I have the following table:   [ORDER] CUSTOMER ID   NORDER   NET AMOUNT C1                        1               100 C1        ...
Need Help
pragathi's avatar
pragathi
Regular Visitor
3 years ago

Hi, I have requirement with having clause and also distinct count and sum function in two different tables.

Can anyone help me how to write the measure for it.

Below is the logic we need to implement as measure.

 

Count distinct userevents.outletcode having sum(userevents.sessioncount)>0/ count of distinct outlet.outletcode where b2b flag=""x"" and outlet.outletstatuscodd=""2"" and outlet.b2bstartdate<=<date selected>

 

Kindly help how to implement this logic in dax