Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |