Forum Discussion

koningii's avatar
koningii
Frequent Visitor
6 years ago

DAX Help needed for count & filtering

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 wan...
koningii's avatar
koningii
Frequent Visitor
6 years ago

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's avatar
saraMissBI
Icon for Resolver I rankResolver I
6 years ago

Hi koningii 

 

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

 

Best Regards,

 

 

  • koningii's avatar
    koningii
    Frequent Visitor
    6 years ago

    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