Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Help please
I have a Matrix visual with two row fields. The calculated measure below only works when I have one field and not two. Please assist
Product_Code_Desc | Sub_Product_Desc | Sales MTD |
Prod_1 | sub_prod_1 | 586 |
Prod_1 | sub_prod_2 | 1 |
Prod_1 | sub_prod_3 | 44 |
Prod_1 | sub_prod_4 | 40 |
Prod_1 | sub_prod_5 | 5 |
Prod_1 | sub_prod_6 | 1 |
Prod_1 | sub_prod_7 | 1 |
Prod_1 | sub_prod_8 | 25 |
Prod_1 | sub_prod_9 | 2 |
Prod_1 | sub_prod_10 | 2 |
Prod_1 | sub_prod_11 | 3 |
Prod_1 | sub_prod_12 | 1 |
Prod_1 | sub_prod_13 | 10 |
Prod_1 | sub_prod_14 | 361 |
Total | 697 | |
Prod_2 | sub_prod_15 | 1 |
Prod_2 | sub_prod_16 | 13 |
Prod_2 | sub_prod_17 | 559 |
Prod_2 | sub_prod_18 | 18 |
Prod_2 | sub_prod_19 | 653 |
Prod_2 | sub_prod_20 | 3 |
Prod_2 | sub_prod_21 | 34 |
Prod_2 | sub_prod_22 | 35 |
Prod_2 | sub_prod_23 | 8869 |
1268 | ||
Solved! Go to Solution.
Seems like there is some missing information here. Like a date table, some relationships to the date table, etc.
Is that source data you present and what is the measure name for the formula you provided?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Seems like there is some missing information here. Like a date table, some relationships to the date table, etc.
Is that source data you present and what is the measure name for the formula you provided?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |