PowerBi - Trying to display on a card the Distinct Count of Store names on if the sum value in the table is either Positive or Negative

MikeCobra

New Member
Joined
May 3, 2023
Messages
12
Office Version
  1. 365
Platform
  1. Windows
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?
 

Attachments

  • Image 1.png
    Image 1.png
    16.8 KB · Views: 5
Just to provide an update - this have been solved by using this Dax Measure:
var Test2 = COUNTROWS(
FILTER(
VALUES(tbl_Stores[Store ID]),
left([M_Test_Average_Variance] ,1) = "-"
)
)

this looks different to above but in general. Where Store ID is - that is your grouping your go against and the M_Test_Average_Variance is the criteria.
 
Upvote 0

Forum statistics

Threads
1,226,795
Messages
6,193,047
Members
453,772
Latest member
aastupin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top