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

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago

Thanks, your measure worked great, but then reaslied the result wasnt exactly what I wanted.  I now have a table similar to the below

 

The chart is then conting each row, so Negative = 2, Positive = 2 & 0 = 1, but I realised that I need it to count each distinct country, so Negative = 1 (UK) , Positive = 1 (France) & 0 = 2 (Germany & Spain).

 

I am trying "DistinctCount" with your measure, but can figure it out.  Hope that makes sense.

Pragati11's avatar
Pragati11
Super User
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