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 All,
I have the following problem:
I want a graph to display values only when values have been selected on both filtered but it won't work.
Here is an example:
1. The current configuration on my filteres is : the competitors filter will adjust itself based on the value selected on the Lookup filter.
To do this, I created the following mesure:
Measure = VAR _typeid = SELECTEDVALUE ( LOOKUP[promo type ID] ) RETURN IF ( MAX ( 'FACT'[promo type ID] ) = _typeid, MAX ( 'FACT'[Competitor ID] ) )
2. to display the values only when selection has been made on both filters, I created the two following mesures:
Solved! Go to Solution.
@Chrisjr , Change and && to OR || as per need in given measure
measure =var _1 = int(calculate( ISFILTERED('LOOKUP'[promo type]) ,allselected()))
var _2 int(calculate( ISFILTERED(Competitors[competitor]) ,allselected()))
return
if(_1= 1 && _2=1, 1,0)
@Chrisjr , Change and && to OR || as per need in given measure
measure =var _1 = int(calculate( ISFILTERED('LOOKUP'[promo type]) ,allselected()))
var _2 int(calculate( ISFILTERED(Competitors[competitor]) ,allselected()))
return
if(_1= 1 && _2=1, 1,0)
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |