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,
I have a table called TABLE1 as shown below. I have created 2 measurres
1- CALCULATE(SUM(TABLE1[VALUE), FILETER(Table1, TABLE1[Categorey = "A"))
2- CALCULATE(SUM(TABLE1[VALUE), FILETER(Table1, TABLE1[Categorey = "B"))
I brought Matrix visual as shown below, but now I need to show the differnce between Sales and value at the row level, I created another measure Difference = Measurre 1 - Measuer 2, but if I drag that into visual, it appears as a row.
Thanks
Solved! Go to Solution.
Hi @sabeensp ,
Whether is there any other field that can judge the relationship between sales and target value, such as date field? If no, you may get only one row with summarized value finally.
Best Regards
Rena
I'm not sure I'm following this. 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
Hi @sabeensp ,
Is there an one-to-one correspondence between sales and target value of your source data ? For example , 100 for sale correspond to target 30 , 150 for sales corresponds to target 35 and 200 for sales corresponds to target 40 ? If yes , you can process it on the source data side , and pivot the sales value and target values into 2 columns as shown in the following figure . You can view my shared sample file for details .
Best Regards
Rena
@v-yiruan-msftNo there is no 1:1 relationship not all forecast will have sales and vise versa.
Hi @sabeensp ,
Whether is there any other field that can judge the relationship between sales and target value, such as date field? If no, you may get only one row with summarized value finally.
Best Regards
Rena
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |