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

I think filter should also be moved inside summarize , other than > 5

,'edw DimFeature'[FeatureName] in {"Action Cards","Drug List","klpAnswer","klpResult","klpStart","Practical Procedures","Video Chapter","videoFull"}

lmat's avatar
lmat
Frequent Visitor
6 years ago

Thank you amitchandak. I am so new to PowerBI I don't fully understand where I move filter to inside summarise - please can you explain? Thanks!

  • 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)))