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.
I use the below measure for identifying the spend against the filter in it
Contract Reference =
VAR Test =
COUNTROWS (
FILTER (
'Agreement',
'Agreement'[Supplier Group] = Sievo[Supplier group]
&& 'Agreement'[Subcategory] = Sievo[Type]
&& 'Agreement'[Entity] = Sievo[Entity]
&& Sievo[PO date] > 'Agreement'[Effective date].[Date] && Sievo[PO date] < 'Agreement'[End date].[Date]
)
)
RETURN
IF ( Test = 0, "No", "Yes" )
But in the above measure I have to insert one exclusion as
If the value of Entity = Group, "&& 'Agreement'[Entity] = Sievo[Entity]" shoud not apply
If the Entity is any value but not Group then the filter "&& 'Agreement'[Entity] = Sievo[Entity]" has to apply on the above measure.
Please help
Solved! Go to Solution.
Hi @mahra-in,
If I understand you correctly, the formula below should work in your scenario.
Contract Reference = VAR Test = COUNTROWS ( FILTER ( 'Agreement', 'Agreement'[Supplier Group] = Sievo[Supplier group] && 'Agreement'[Subcategory] = Sievo[Type] && ( 'Agreement'[Entity] = "Group" || 'Agreement'[Entity] = Sievo[Entity] ) && Sievo[PO date] > 'Agreement'[Effective date].[Date] && Sievo[PO date] < 'Agreement'[End date].[Date] ) ) RETURN IF ( Test = 0, "No", "Yes" )
Regards
Hi @mahra-in,
If I understand you correctly, the formula below should work in your scenario.
Contract Reference = VAR Test = COUNTROWS ( FILTER ( 'Agreement', 'Agreement'[Supplier Group] = Sievo[Supplier group] && 'Agreement'[Subcategory] = Sievo[Type] && ( 'Agreement'[Entity] = "Group" || 'Agreement'[Entity] = Sievo[Entity] ) && Sievo[PO date] > 'Agreement'[Effective date].[Date] && Sievo[PO date] < 'Agreement'[End date].[Date] ) ) RETURN IF ( Test = 0, "No", "Yes" )
Regards
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |