Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello experts.
I have a table that contains data in following format
Build ver Color
12 1.0.1 blue
12 1.0.3 red
13 2.0.4 blue
13 2.0.5 orange
12 3.0.2 blue
I want to create a measure that if is ‘12’ and ‘blue’, it will filter only
12 1.0.1 blue
12 3.0.2 blue
This works for only one criteria
Measure = COUNTROWS(FILTER(UnifiedInstallers,UnifiedInstallers[Color]="blue")) but I need the Build too.
Any help is greatly appreciated
Solved! Go to Solution.
Hi @BEC_100
You can use && to concatenate multiple criteria. For example,
Measure =
COUNTROWS(FILTER(UnifiedInstallers,UnifiedInstallers[Color]="blue" && UnifiedInstallers[Build]="12"))
If the Build column is Number type, remove the double quotes around 12.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @BEC_100
You can use && to concatenate multiple criteria. For example,
Measure =
COUNTROWS(FILTER(UnifiedInstallers,UnifiedInstallers[Color]="blue" && UnifiedInstallers[Build]="12"))
If the Build column is Number type, remove the double quotes around 12.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |