DAX Help needed for count & filtering

Question

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 · Answer

Hi&nbsp;koningii&nbsp;&nbsp;Could you provide sample data of what you have, please? it would help come up with the right formula.&nbsp;Best Regards,

koningii · Answer

saraMissBI&nbsp;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 &gt;0 and percentage &lt;0.&nbsp;Product Portfolio &nbsp; &nbsp;Count of Result &nbsp; &nbsp; &nbsp; &nbsp;Results &gt; 0. &nbsp; &nbsp;Results &lt; 0. &nbsp; &nbsp; Percentage &gt;0 &nbsp; &nbsp; &nbsp; Percentage &lt;0A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 47264B. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8615C. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5543D. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 737E. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 491F. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 281G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 161Total. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 63092

saramissbi · Answer

Hi&nbsp;koningii&nbsp;&nbsp;I see, in the sample data you shared, all results are positive. Is that correct in your case?&nbsp;Best Regards,&nbsp;&nbsp;

koningii · Answer

saraMissBI&nbsp;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.&nbsp;&nbsp;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)&nbsp;Product Portfolio &nbsp; &nbsp;Count of Result &nbsp; &nbsp; &nbsp; &nbsp;A. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 47264B. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8615C. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5543D. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 737E. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 491F. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 281G. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 161Total. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 63092

Forum Discussion

DAX Help needed for count & filtering

4 Replies

Related content

Filter participant counts

Filter and Count

Counting nulls

I need help with Distinct Count with excluding filter

Help with matrices slicers, filters and dynamic counts