When I create a quick measure (visual-level calculation), I need to reference a column from the data table as the base. However, when I try to create this calculation in a visual where I’m using a field parameter, the column name changes depending on the selected parameter field, and as a result, the visual-level calculation throws an error.
Is there any way to make this work?
3 Comments
kleighResponsive Resident
There isn't a solution at the moment - it is on the roadmap : https://community.fabric.microsoft.com/t5/Desktop/Share-your-thoughts-on-visual-calculations-preview/m-p/4744947#M1415334
GepaxAdvocate I
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
Microsoft Employee
Status changed:NewtoNeeds Votes
