Cannot Convert value of type text to type true false

[Laura0403]

Hi, 

I know there are a lot of solutions to this topic here. Unfortunatly I can't help myself by reading them.

I wanted to do calculate formula to get the values for the visual. I can't use my measure in the visual because of the error "Cannot Convert value of type text to type true false".

Berechneter Frachtumsatz =

CALCULATE (

    [Umsatz ohne GS],

    Prdo5_Sales[Artikel.Artikel Nr] = "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR_EDI",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR_AUTO",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR_AUTO_MD",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR_AUTO_X",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR_EDIMAUT",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FRACHTKOST",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FRACHTP",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR-HARDW",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FR-VBM",

    "FRACHT"

        || Prdo5_Sales[Artikel.Artikel Nr] = "FRACHT"

)

This is the whole Measure. 

Can someone help me? 
Thanks in advance 🙂 

[Anonymous · Accepted solution]

Hi @Laura0403 ,

Please use the below to shorten your code. Also could you check your data type for  [Umsatz ohne GS] is it in text?

Berechneter Frachtumsatz = =
CALCULATE (
    [Umsatz ohne GS],
    Prdo5_Sales[Artikel.Artikel Nr]
        IN {
        "FRACHT",
        "FR_EDI",
        "FR_AUTO",
        "FR_AUTO_MD",
        "FR_AUTO_X",
        "FR_EDIMAUT",
        "FRACHTKOST",
        "FRACHTP",
        "FR-HARDW",
        "FR-VBM",
        "FRACHT"
    }
)

BR

[Laura0403]

Hi,

that worked, thanks a lot.

But I still don't understand why it worked. Can you maybe be so kind and explain it a little? 🙂

[Anonymous]

Hi @Laura0403 ,

This would be a syntax issue, the word "FRACHT" has been repeated in every filter argument.
In your case the text operator " || " would still work but would need to revised to follow as per 2nd example below:

BR 

[Laura0403]

Ahhh I understand. Thanks a lot 🙂