Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
koningii
Frequent Visitor

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 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. 

4 REPLIES 4
saraMissBI
Resolver I
Resolver I

Hi @koningii 

 

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

 

Best Regards,

@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

Hi @koningii 

 

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

 

Best Regards,

 

 

@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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.