Convert Calculated Column to a measure

Question

Hi there,I have a table with Regions and Sales and Template Name (for sorting)The Column Regions contain duplicate regions names associates with different sort orders this sort order attach to a slicerso I created a calculated column looks like thatTotal Sales by Region = Calculate(Sum(Sales[Sales]),Filter(Sales,Sales[Regions] = EARLIER(Sales[Regions])))This works fine because the calculated calumn group the sales by region regardless to the slicer selection.How do I convert this calculated calumn to a measure that perform the grouping and ignore the slicer selection?ThanksOded Dror&nbsp;&nbsp;

oded-dror · Accepted Answer

I solved the measure calculaion =&nbsp;CALCULATE(SUM(Sales[Sales]),Filter(ALL(Sales),Sales[Regions] = SELECTEDVALUE(Sales[Regions])))

Forum Discussion

Convert Calculated Column to a measure

1 Reply

Related content

Convert calculated column into measure

DAX Calculated Measure

Measure converted to Calculated column shows different result

Convert measure to column

Converting calculated column into parameter