Forum Discussion
Remove duplicates if condition is met
Hi lc1
Would a measure like this help?
Flag =
VAR _Proj = MAX( 'Table1'[Proj ID] )
VAR _Table =
FILTER(
ALL( 'Table1' ),
'Table1'[Proj ID] = _Proj
)
VAR _All = COUNTROWS( _Table )
VAR _PTP =
COUNTROWS(
FILTER(
_Table,
'Table1'[Fund] = "PTP"
)
)
VAR _Logic = IF( _All = _PTP, 1 )
RETURN
_Logic
That flag can be used to filter your visual.
Remove duplicates if condition is met.pbix
Thank you all for the responses, I tried the various solutions but could not get the results I'm looking for.
I should've mentioned I'm working with data coming from 4 different tables:
| Table 1 | Table 2 | Table 3 | Table 4 |
| Completion Date | Total Expenditures | *Project ID | * Revenue Name |
| * Distinct value (key) |
I need to create two matrixes, one with a list of projects that are 100% funded by Revenue type 1 and one table with projects that are fully and partially funded with Revenue type 1.
Meaning, the second table should have all projects funded 100% with Rev type 1 in addition to other projects funded with other types of revenue.
Hi lc1
I would like to help but I'm a little unclear about your requirements.
Can you provide the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/14475233) Please explain how you would expect to get from step 1 to 2.
4) If possible, please show your past attempts at a solution.
A .pbix file with sample data would be best.