Forum Discussion

gregst's avatar
gregst
Frequent Visitor
1 year ago
Solved

New Visual Calculation error with measure with Dynamic Format

I don't know if this issue is already raised but when I have a measure with a Dynamic Format the New Visual Calculation gives me an error:

Error fetching data for this visual DAX comparison operations do not support comparing values of type text with values of type integer...

 

the chart is a stacked column with on measure inside (with the dynamic format). 

The measure I added is well calculated in the table but the chart gives the error. And cannot be displayed.

If I remove the dynamic format the error disappears.

my Dynamic format is like that:

VAR _unit = 
    SWITCH(
        SELECTEDVALUE('Table Units'[Units]),
        "Unit","#,##0",
        "Kunit","#,##0k",
        "Munit","#,##0M"
    )
VAR _type =
    SWITCH(
        SELECTEDVALUE('Table Type'[Units]),
        "Dollars","$",
        "Quantity",""
    )
    
RETURN
_unit&_type

 

Need Help

2 Replies

  • speedramps's avatar
    speedramps
    Super User
    1 year ago

    I want to help you but your description is too vague. Please write it again.


    You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming


    * Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy). ‌‌
    * Please DO give a simple non-technical functional description of what you want
    * Keep it simple and break large projects into smaller questions and ask just one question per ticket.
    * Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
    * Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
    * Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
    * Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
    * Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
    * Remember not to share private data ... we don't want you to get into trouble. ‌‌
    * Please click the thumbs up button for these helpful hints and tips. Thank you.


    Learn how to attach data in the forum using OneDrive:-
    * Save your file in a OneDrive folder
    * Right click on the file and click the “Share” blue cloud icon
    * Click the bottom “Copy” button
    * Click” Anyone with link can edit”
    * Click “Can Edit”
    * Click “Can View”
    * Click “Apply” button
    * Click “Copy”
    * Paste the generated link via the forum, email, chat, or any other method.
    * Helpers can then download your data, build a solution and share it back.


    Learn how to attach data in the forum using Dropbox:-
    1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
    2. Select File/Folder: Find the file or folder you want to share.
    3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
    4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
    5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.