Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax Measure for Range

Hi Any DAX Expertise Here?   My Access Count is a count column from my data source. May I ask any DAX measure that I can use to filter out   Access Count >10 Access Count <0 Access Count >5 & ...
Need Help
Show and Tell
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create Range table via "Enter Data" under Home ribbon.

     

     

     

     

    Then create column Range Judge to judge range, or you may create column Range Judge1 which won't need the Range table.

     

     

    Range Judge = CALCULATE(VALUES(Range[Access Count range]),FILTER(Range,Table1[Access Count]>=Range[Min]&&Table1[Access Count]<=Range[Max]))

     

    Range Judge1 = SWITCH(TRUE(),Table1[Access Count]<=0,"Count of Login <= 0",Table1[Access Count]>0&&Table1[Access Count]<=5,"Count of Login > 0 & <= 5",Table1[Access Count]>5&&Table1[Access Count]<=10,"Count of Login >5 & <= 10",Table1[Access Count]>10,"Count of Login >10")

     

     

     

     

     

     

    Here is my test pbix: https://community.powerbi.com/t5/Desktop/Dax-Measure-for-Range/m-p/689458#M332430

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

TomMartens's avatar
TomMartens
Super User
7 years ago
Hey,

please prepare a pbix file that contains sample data and reflects your data model, upload the to onedrive or dropbox and share the link.

Regards,
Tom
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi TomMartens 

 

Can you send me your email instead?

 

My source file and access are confidential and restricted.

 

I will revise the source file and send to you.

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago
    Hey,

    confidential data is exactly the reason why I'm asking for sample data 😉

    Regards,
    Tom
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      Hi TomMartens 

       

      Here is the sample data, can you import into your PowerBI and share me the Dax ,

       

      Filter by Count of Login >10

      Count of Login < 0

      Count of Login >5 & < 10

      Count of Login > 0 & < 5

       

      UserTime of Login
      A1/1/2015
      A2/1/2015
      B3/1/2015
      B4/1/2015
      B5/1/2015
      C6/1/2015
      D7/1/2015
      D8/1/2015
      D9/1/2015
      D10/1/2015
      D11/1/2015
      A12/1/2015
      A13/1/2015
      A14/1/2015
      B15/1/2015
      C16/1/2015
      C17/1/2015
      C18/1/2015
      C19/1/2015
      D20/1/2015
      D21/1/2015
      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        Hi Anonymous ,

         

        You can create Range table via "Enter Data" under Home ribbon.

         

         

         

         

        Then create column Range Judge to judge range, or you may create column Range Judge1 which won't need the Range table.

         

         

        Range Judge = CALCULATE(VALUES(Range[Access Count range]),FILTER(Range,Table1[Access Count]>=Range[Min]&&Table1[Access Count]<=Range[Max]))

         

        Range Judge1 = SWITCH(TRUE(),Table1[Access Count]<=0,"Count of Login <= 0",Table1[Access Count]>0&&Table1[Access Count]<=5,"Count of Login > 0 & <= 5",Table1[Access Count]>5&&Table1[Access Count]<=10,"Count of Login >5 & <= 10",Table1[Access Count]>10,"Count of Login >10")

         

         

         

         

         

         

        Here is my test pbix: https://community.powerbi.com/t5/Desktop/Dax-Measure-for-Range/m-p/689458#M332430

         

        Best Regards,

        Amy

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.