Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |