Forum Discussion
Helper IIIUsing ALLSELECTED in Divide function
Still no coding required.
Hi MichaelaMul ,
Thanks for the reply from lbendlin .
I do not really know what kind of desired effect you want.
What do SUM('DATA'[CY Reforecast] and SUM('DATA'[Volume]) mean respectively? Why do you divide them?
I would appreciate it if you could provide me with sample data and a diagram of the desired effect, please remove any sensitive data in advance.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Helper IIIHi thanks for the reply! I made a typo and updated the formulas above. Here's the sample data.
CategoryTable:
| Product Group | Category |
| LIGHT SOUR CREAM | SOUR CREAM |
| SOUR CREAM | SOUR CREAM |
| SKIM MILK | MILK |
| WHOLE MILK | MILK |
| 1% MILK | MILK |
| 2% MILK | MILK |
| ORANGE JUICE | DRINKS |
| CREAMER | CREAMER |
| NON-DAIRY CREAMER | CREAMER |
| LIGHT CREAM | CREAMER |
| SPRING WATER | DRINKS |
DATA table:
| Store | Brand | Product Group | Time Period | Volume |
| STORE A | ABC | LIGHT SOUR CREAM | March | 12,525 |
| STORE A | ABC | LIGHT SOUR CREAM | February | 11,340 |
| STORE A | ABC | LIGHT SOUR CREAM | January | 9,720 |
| STORE A | ABC | SOUR CREAM | March | 42,134 |
| STORE A | ABC | SOUR CREAM | February | 35,280 |
| STORE A | ABC | SOUR CREAM | January | 26,880 |
| STORE A | ABC | SKIM MILK | March | 1,645 |
| STORE A | ABC | SKIM MILK | February | 1,476 |
| STORE A | ABC | SKIM MILK | January | 1,684 |
| STORE A | ABC | SKIM MILK | March | 5,300 |
| STORE A | ABC | WHOLE MILK | February | 5,157 |
| STORE A | ABC | WHOLE MILK | January | 5,711 |
| STORE A | ABC | WHOLE MILK | March | 7,900 |
| STORE A | ABC | WHOLE MILK | February | 7,408 |
| STORE A | ABC | WHOLE MILK | January | 8,632 |
| STORE A | ABC | WHOLE MILK | February | 3 |
| STORE A | ABC | SKIM MILK | January | 4 |
| STORE A | ABC | SKIM MILK | March | 711 |
| STORE A | ABC | SKIM MILK | February | 667 |
| STORE A | ABC | SKIM MILK | January | 712 |
| STORE A | ABC | ORANGE JUICE | March | 65 |
| STORE A | ABC | ORANGE JUICE | February | 59 |
| STORE A | ABC | ORANGE JUICE | January | 95 |
| STORE A | ABC | ORANGE JUICE | March | 154 |
| STORE A | ABC | 2% MILK | February | 136 |
| STORE A | ABC | 2% MILK | January | 148 |
| STORE A | ABC | 2% MILK | March | 228 |
| STORE A | ABC | 2% MILK | February | 212 |
| STORE A | ABC | 2% MILK | January | 226 |
| STORE A | ABC | CREAMER | March | 87 |
| STORE A | ABC | CREAMER | February | 105 |
| STORE A | ABC | CREAMER | January | 102 |
| STORE A | ABC | NON-DAIRY CREAMER | March | 8,237 |
| STORE A | ABC | NON-DAIRY CREAMER | February | 7,440 |
| STORE A | ABC | NON-DAIRY CREAMER | January | 3,360 |
Thanks!
- lbendlin
Super User
Like this?
- MichaelaMul
Yes! The sample data doesn't show it but there are other brands and stores in the table, so I can't just total the column.
- lbendlin
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.