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

Hi koningii 

 

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

 

Best Regards,

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