Forum Discussion
Visual with incomplete information - Relationships
Hi Andvil ,
Maybe you can use Measure instead of columns, like the following example.
Replace Item Column with Item Measure and put it in Values
Item Measure = var _x = CALCULATE(SUM('2020'[ITEMS])) return IF( ISBLANK(_x),"",_x)If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Andvil - Maybe. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg_Deckler
1) I attach an example file: PBI FILE
2) My output is to have under each employee and the sales codes, another row with a blank (as no employees are assigned) and the remaining sales codes that were not paired. There are more explanations in my previous messages.
As you can see in this picture, "01777794-Astet Agentes" has 668 purchases. 458 sales codes were assigned to an employee, however, 210 sales codes were not assigned and not shown in the table. Under the employee and the 458 sales, I should have a blank field in employee and then 210 under the 458, that way it matches the 668 total sales. I have enabled the "show items with no data" but still the information not assigned to an employee is not showing.
3) Power Bi must somehow show the information that has not been paired to an employee or agency, Imagine you have that column and not all the fields are filled with employee information, when adding the visual, you would have in blank all the sales that have not been assigned to an employee.
Best,
Hi Andvil ,
Maybe you can use Measure instead of columns, like the following example.
Replace Item Column with Item Measure and put it in Values
Item Measure = var _x = CALCULATE(SUM('2020'[ITEMS])) return IF( ISBLANK(_x),"",_x)If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.