Union filtered metric results

[rdg515]

Ultimately, I want to be able to use a waterfall chart, but in order to do so it requires my results to be in a certain format, i.e.  rows of Category | Value pairs.

The measures I want to use for the waterfall chart exist on two tables, and I have two date slicers (one slicer for each table) with cards showing the results of the measures as the slicers are dynamically adjusted.  

Is it possible to union the two measures together into a table with the necessary Category | Value format for the waterfall chart, AND have the slicers dynamically impact the results of that unioned table?

[v-jiascu-msft]

Hi @rdg515,

Can you share a sample, please? Please mask the sensitive parts first. 

If the two tables have proper relationships, you can unite the two measures easily. 

Best Regards,
Dale

[rdg515 · Accepted solution]

My colleague figured out the solution to being able to use a waterfall visual with measures. Step 1: Create a table with the necessary Waterfall visual format. Note, the value is not included here. Waterfall = UNION( Row("Category","Baseline","SortBy",1), Row("Category","Volume","SortBy",2), Row("Category","Performance","SortBy",3) ) Step 2: Create a value measure which is nothing but a switch that uses the appropriate measure results for each category. Value = sumx(Waterfall, Switch(Waterfall[Category], "Baseline", [mRepeatCalls], "Volume", [mVolume], "Performance", [mPerformance] ) )

[v-jiascu-msft]

Thanks for sharing, @rdg515.

Best Regards,
Dale