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.

     

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.