Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conversion Issue

Hi Microsoft Team,

 

I am getting an error as follows
"Cannot Convert value 'Australia' of type text to type True/false.

 

The measure is as follows:

Comparable Left =
Var _a_left_value=CALCULATE([SP], FILTER('Store',Store[RUName]))
return
_a_left_value

Note:  [SP] is a measure 

Help me to overcome that error


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

    Hi Anonymous ,

     

    Suppose you need to retrieve the following table using those filters.

     


    If the table has created relationships with other tables, then you can filter directly. 

     

     

     

    If there is no relationship between theses tables, please create the following measure.

     

    Measure = 
CALCULATE (
    [SP],
    FILTER (
        'Table 2',
        'Table 2'[Date] IN ALLSELECTED ( 'Date'[Date] )
            && 'Table 2'[item] = SELECTEDVALUE ( 'Item'[itemName] )
            && 'Table 2'[Product] = SELECTEDVALUE ( 'Product'[ProductName] )
            && 'Table 2'[RU] = SELECTEDVALUE ( Store[RUName] )
    )
)

     

    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.

     

6 Replies

  • truptis's avatar
    truptis
    Community Champion
    4 years ago

    Hi Anonymous ,

    Try this:

    Comparable Left = var selection = Selectedvalue(Store[RUName])
    Var _a_left_value=CALCULATE([SP], FILTER('Store',Store[RUName]=selection ))
    return
    _a_left_value
     
    Anonymous -> Please mark this as a solution & hit the thumbs up if it helps you. Thanks.
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Truptis,

       

      After trying the below code also, 
      Comparable Left = var selection = Selectedvalue(Store[RUName])
      I was getting this error ""Cannot Convert value 'Australia' of type text to type True/false."


      Any other logic please?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 
    you need to complete this filter condition here 

    something like FILTER('Store',Store[RUName] = "Australia") etc. or whatever filter condition you want to put here.

    Regards,
    Aditya

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Aditya,
      It should pick dynamically like = Selectedvalue(Store[RUName])
      When I am giving as above it was throwing same error like conversion issue

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Aditya,
        I have few tables - Date, Store, Item , product tables

        From Date Table - Date(YEAR), Date(Month)
        From Store Table - Store(RUName)

        From Item Table - Item(itemName)
        From Product Table - Product(ProductName)
        And Now I have one Measure ie., [SP]

        I am trying to retrieve the [SP] data with all above filter values 

        Can I get some logic , how I can pass all those filters in DAX

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

    Hi Anonymous ,

     

    Suppose you need to retrieve the following table using those filters.

     


    If the table has created relationships with other tables, then you can filter directly. 

     

     

     

    If there is no relationship between theses tables, please create the following measure.

     

    Measure = 
CALCULATE (
    [SP],
    FILTER (
        'Table 2',
        'Table 2'[Date] IN ALLSELECTED ( 'Date'[Date] )
            && 'Table 2'[item] = SELECTEDVALUE ( 'Item'[itemName] )
            && 'Table 2'[Product] = SELECTEDVALUE ( 'Product'[ProductName] )
            && 'Table 2'[RU] = SELECTEDVALUE ( Store[RUName] )
    )
)

     

    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.