I have a table which has Store ID / Store Name / Sum of RecordCount / SumofVarianceFinal/M_Test_Variance_Average / M_Test_Pos_Neg_Time (See Image 1).
Sum of RecordCound - Just adds up all the records for that store within the date range i've set on the slicer)
Sum Of VarianceFinal - Just adds up the variance totals.
M_Test_Variance_Average - sum VarianceFinal / Sum of RecordCount
M_Test_Pos_Neg_Time - checks Sum of VarianceFinal is its negative or postivie
I want it so that i can display a card visual and it will say x number of Positive Stores and x Number of Negative stores. Making sure that it counts the store once and not mutliple times.
for this example - it would say 2 for negative stores and 2 for positive stores.
I'm having some trouble since the only way i found out the total values are positive or negative is from a measure.
Can anyone help me?
Sum of RecordCound - Just adds up all the records for that store within the date range i've set on the slicer)
Sum Of VarianceFinal - Just adds up the variance totals.
M_Test_Variance_Average - sum VarianceFinal / Sum of RecordCount
M_Test_Pos_Neg_Time - checks Sum of VarianceFinal is its negative or postivie
I want it so that i can display a card visual and it will say x number of Positive Stores and x Number of Negative stores. Making sure that it counts the store once and not mutliple times.
for this example - it would say 2 for negative stores and 2 for positive stores.
I'm having some trouble since the only way i found out the total values are positive or negative is from a measure.
Can anyone help me?