Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago
Solved

Pie Chart: Positive Values vs Negative Values

I have a Measured column that shows the variance between 2 columns..   Measure: Headcount vs Laptops Difference = LAPTOPS[Stock_Count_Measure] - Headcount[Headcount_Measure]   This coulmn will t...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi StuartSmith ,

     

    You can do a caluclation as follows:

    NegaticveCnt = CALCULATE(DISTINCTCOUNT(tablename[Country]), tablename[GroupCol] = "Negative")

     

    Do similar measures for Positive and 0.

     

    Thanks,

    Pragati

Tahreem24's avatar
Tahreem24
Super User
5 years ago

StuartSmith ,
I replicated some sample at my end as per your deets.

SO create first one calculated column:

Category Column =
VAR Diff = TblName[Stock Count Measure] - TblName[Headcount Measure]
RETURN SWITCH(TRUE(),Diff>0,"Positive",
Diff<0,"Negative",
Diff=0,"0 Values")

Then create measure like below:
Count Measure = COUNT(TblName[Category Column])
Then you can put these on pie chart like the attached screen shot: