Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone
I am trying to divide certain values from a column with the total column.
Below is a sample:
Rating Experience
Negative
Negative
Negative
Positive
Neutral
Positive
Neutral
Positive
Negative
I this case I am trying to divide the negatives with the total number of the column.
Solved! Go to Solution.
Try this;
Sample = DIVIDE( CALCULATE( COUNT('Table'[Rating Experience]); 'Table'[Rating Experience]="Negative"); COUNTROWS('Table'))
Greetz,
Ronald
Hi @ionutbolos ,
Here we can format the measure to percentage instead of changing it in visual. As in visual, you might get the percentage of some other category.
I think this should work
Measure= VAR __Count= COUNTROWS( TABLE ) VAR __NegCount = CALCULATE( __Count, TABLE[RATNG EXPERIENCE]= "Negative" ) RETURN DIVIDE (__NegCount,__Count)
Try this;
Sample = DIVIDE( CALCULATE( COUNT('Table'[Rating Experience]); 'Table'[Rating Experience]="Negative"); COUNTROWS('Table'))
Greetz,
Ronald
Thanks! That worked. It shows the correct value (eg. below 0.14) but when it transforms it into percentage in the pie chart it shows a different value. Do you happen to know why it showing like this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |