Forum Discussion

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Share your thoughts on visual calculations (preview)

Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation.   Here are some areas that we'd like to hear ab...
General Comment
Branca32844's avatar
Branca32844
Frequent Visitor
1 year ago

Thanks for the speedy response!

When you say "at the moment", this means it would eventually get solved? Is it on the roadmap? 

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

what I meant is that we are aware but haven't found a solution we like yet. It's on the roadmap, but I don't have a date to share.

  • Gepax's avatar
    Gepax
    Icon for Advocate I rankAdvocate I
    1 year ago

     

    I found an alternative… Ideally, it would work natively with the field parameter, but this is what I managed to do.

    I manually created a field parameter:

     

    prm_M_Tipo_Combustivel =
        DATATABLE(
            "Tipo",
            STRING,
            {
                {"Diesel"},
                {"Arla"}
             }
         )

     

    After that, I created a measure that uses “Measure A” if “Diesel” is selected, or “Measure B” if “Arla” is selected.

    I used this measure in the visual, created a moving average (visual calculation), and it adjusts according to the selected option.

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      1 year ago

      got it, yes that works, but it's a workaround. Ideally this should work more directly. Thanks for sharing!