Forum Discussion

Divous's avatar
Divous
Helper III
4 years ago
Solved

Show values based on filter and text string

Hi community,   I have Table01 like this   customer_id  date  details  info 1  08.01.2022  color  red 1  09.01.2022  size  small 1  10.01.2022  price  100 2  11.02.202...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Divous ,

     

    Please create the measure and filter the visual with measure.

     

    Measure = 
VAR SelectDate =
    SELECTEDVALUE ( Dates[Date] )
VAR _id =
    CALCULATETABLE (
        VALUES ( Table01[customer_id] ),
        FILTER (
            ALLSELECTED ( Table01 ),
            Table01[date] = SelectDate
                && Table01[info] = "big"
        )
    )
RETURN
    IF (
        SelectDate = BLANK (),
        1,
        COUNTROWS ( INTERSECT ( VALUES ( Table01[customer_id] ), _id ) )
    )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Divous , Make sure you use independent date table in slicer

 

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _tab = summarize(filter(all(Table),Table[date] =_max), [customer_id])
return
calculate(count(Table[customer_id]), filter(Table, Table[customer_id] in _tab))

Divous's avatar
Divous
Helper III
4 years ago

Hi amitchandak 

thanks for your response.

I create independent Date table and try to use your measure, but probably I dont know how.


  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Divous ,

     

    Please create the measure and filter the visual with measure.

     

    Measure = 
VAR SelectDate =
    SELECTEDVALUE ( Dates[Date] )
VAR _id =
    CALCULATETABLE (
        VALUES ( Table01[customer_id] ),
        FILTER (
            ALLSELECTED ( Table01 ),
            Table01[date] = SelectDate
                && Table01[info] = "big"
        )
    )
RETURN
    IF (
        SelectDate = BLANK (),
        1,
        COUNTROWS ( INTERSECT ( VALUES ( Table01[customer_id] ), _id ) )
    )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Divous's avatar
      Divous
      Helper III
      4 years ago

      Hi v-kkf-msft Winniz,

       

      thanks for your response!

      It looks great! 

      But, I have found that I need little polishing. I have in the "info" column not only the "big" itself, but it can also be in a sentence. For example, "he wants a big size." So I need to filter that too.

       

      EDIT:

      I use CONTAINSTRING in part of checking "big" and its working.
      Winniz, everything is OK and working. 

      Thanks a lot!