Forum Discussion

lmat's avatar
lmat
Frequent Visitor
6 years ago

Creating a count measure with OR

Hi,   I am new to PowerBI and am working on a dashboard a previously colleague made. There is one measure I am unsure if working as intended. I would like to count all the users who have been in a ...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Try

 
 EngagedUsers = CALCULATE(COUNTROWS(FILTER(SUMMARIZE(filter('edw FactUsage','edw DimFeature'[FeatureName] in {"Action Cards","Drug List","klpAnswer","klpResult","klpStart","Practical Procedures","Video Chapter","videoFull"}),[AppId],"ABCD",[UniqueSessionsCount]),[ABCD]>5)))
lmat's avatar
lmat
Frequent Visitor
6 years ago

Unfortunately it doesn't work. I end up with :

 

 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try like

    EngagedUsers = CALCULATE(COUNTROWS(FILTER(SUMMARIZE(calculatetable('edw FactUsage','edw DimFeature'[FeatureName] in {"Action Cards","Drug List","klpAnswer","klpResult","klpStart","Practical Procedures","Video Chapter","videoFull"}),[AppId],"ABCD",[UniqueSessionsCount]),[ABCD]>5)))