Product Trending Dashboard.

[Anonymous]

I'm currently trying to create a dashboard to highlight volume of tickets that have been raised today for a product. If the volume is higher than the average daily volume then it displays this on a chart.

Using 3 measures:

INC_Average_Submitted = 
AVERAGEX(
	VALUES('DimDate'[Date]),
	CALCULATE(COUNTA('DimTable'[Product Name]))
)

INC_Submitted = 
CALCULATE (
    COUNT('DimTable'[Product Name]),
    DimDate[Date] = Today()
)

INC_Flag = 
    IF ('DimTable'[INC_Submitted] > 'DimTable'[INC_Average_Submitted], 1, 0)

I am able to produce a table to highlight the products. However the issue I'm facing is when trying to output the actual ticket references it's returning all values and not those filtered by the above.

How do I amend this to only show tickets that were flagged.

[v-lionel-msft]

Hi @Anonymous ,

Please give us an example of the data used in your formula.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , put a visual level filter INC flag <>0

or try this Measure like

INC_Flag =
calculate( IF ('DimTable'[INC_Submitted] > 'DimTable'[INC_Average_Submitted], 1, 0), filter('DimTable','DimTable'[INC_Submitted]>'DimTable'[INC_Average_Submitted]))