DAX Help needed for count & filtering

[koningii]

I am figuring out which dax formula I need to use for. I want in 1 table a row with the count of results,  a row with results that are >0 a row of results that are <0. With this in a table then I want to have the total percentage in a pie charta with the percentage of results >0 and a row with the percentage of results <0. 

I need some guidance. Please help me out. As I am new to this complexity of DAX I need some help. 

[saraMissBI]

Hi @koningii 

Could you provide sample data of what you have, please? it would help come up with the right formula.

Best Regards,

[koningii]

@saraMissBI Here is the sample data. The count I did now with Field then changed value into count. After the table I need to create a pie chart with only percentage >0 and percentage <0.

Product Portfolio    Count of Result        Results > 0.    Results < 0.     Percentage >0       Percentage <0

A.                             47264

B.                             8615

C.                             5543

D.                             737

E.                             491

F.                             281

G.                           161

Total.                     63092

[saraMissBI]

Hi @koningii 

I see, in the sample data you shared, all results are positive. Is that correct in your case?

Best Regards,

[koningii]

@saraMissBI These data I provided are now only counts of all results and does not say if it is negative of positive. I have putted in the fields I would like. 

The real sample data looks like this in the table in powerbi. (Result is column in my dataset and product portfolio is a column in my dataset)

Product Portfolio    Count of Result        

A.                             47264

B.                             8615

C.                             5543

D.                             737

E.                             491

F.                             281

G.                           161

Total.                     63092