The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello
I have a table with Itens, in this case is (mycat)
Please help me to find out a way to calculate my MyfiltCol base on my max 2 selections exemple below
Table:
Filter and formula
Problem!! if i select 3 values (A , Band C ) should change to blank but is not working =(
Please can some one help me ?
Solved! Go to Solution.
Hi @Anonymous
Try something like.
Measure =
IF(
COUNTROWS( ALLSELECTED( 'Table'[Column1] ) ) <= 2,
COUNTROWS( 'Table' ),
"blank"
)
Hi @Anonymous
Try something like.
Measure =
IF(
COUNTROWS( ALLSELECTED( 'Table'[Column1] ) ) <= 2,
COUNTROWS( 'Table' ),
"blank"
)
Tank you alot work perfect for my needs 😃 5 stars
User | Count |
---|---|
70 | |
64 | |
61 | |
49 | |
28 |
User | Count |
---|---|
117 | |
81 | |
65 | |
55 | |
43 |