Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the below measure:
Solved! Go to Solution.
@DW868990 , Measure seem fine to use that as the visual level filter and check for not blank
or try like
Sales (Return when 2 selected only) =
VAR CountryCount = CALCULATE(DISTINCTCOUNT(Sales[Country]), ALLSELECTED(Sales))
VAR Result = IF(CountryCount = 2, [Sales], BLANK())
RETURN
Result
Thank you!
Worked great, with that little tweak 🙂
@DW868990 , Measure seem fine to use that as the visual level filter and check for not blank
or try like
Sales (Return when 2 selected only) =
VAR CountryCount = CALCULATE(DISTINCTCOUNT(Sales[Country]), ALLSELECTED(Sales))
VAR Result = IF(CountryCount = 2, [Sales], BLANK())
RETURN
Result
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |