Forum Discussion
Need Help with Power bi
Here you go
Thanks for your time and reply,
It is not working as exepted.
The thing is that I have one table visual with columns Accid from Account table and Sales, One filter with Owner coming from account table,
Now when I am trying to filter data by selecting any owner from filter it is taking Owner from account matching it with owner column in sales table, Instead of that it should match it with Trader column in sales table.
As per above sample, Suppose I am selecting
| Daniel Madio |
Than output in table should be------Right
| 7C80A27A-46B8-E811-A978-000D3AF49C6C |
| 3,251.10 |
37EA4450-D698-E911-A982-000D3AF490CC
2,595.72
It is giving me output as----- Wrong
37EA4450-D698-E911-A982-000D3AF490CC
2,595.72
37EA4450-D698-E911-A982-000D3AF490CC
| 2,595.70 |
Super UserI've edited my original post to use the correct column.
I've tried by that way but it is giving same value for all the account in table.
- johnt75
It works for me using the sample data if I put the account id from the sales table in the visual
Yes, that way it will work but I do have some other data in table, So I have to use accounts from Account table only