Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
On a previous post I received amazing help in: "Filter single column with multiple conditions (words in a string)"
Solved: Re: Filter single column with multiple conditions ... - Microsoft Power BI Community
Find text that has "red" and "green" in single column
Selector Measure =
VAR __Name = MAX('Table'[NAME])
VAR __Table = SUMMARIZE('Table',[NAME],"__STRING",CONCATENATEX('Table',[STRING]))
VAR __Table1 = ADDCOLUMNS(__Table,"__Red",SEARCH("red",[__STRING],,0),"__Green",SEARCH("green",[__STRING],,0))
VAR __Names = DISTINCT(SELECTCOLUMNS(FILTER(__Table1,[__Red]>0 && [__Green]>0),"__Name",[NAME]))
RETURN
IF(__Name IN __Names,1,0)
I want to count the results of the Measure and followed this post and few others but could not get it to work.
Solved: Is it possible to count the result of a measure? - Microsoft Power BI Community
As always, any insight would be appreciated!
Solved! Go to Solution.
// You can hide the [Selector Measure]
// from the user's view and use the following
// instead. It'll do what the other does
// and also will summarize correctly unlike the other.
// You can also replace the [Selector Measure]
// with its body inside the new measure and
// then get rid of the old one completely.
// Up to you.
[Your New Measure] =
sumx(
values( 'Table'[Name] ),
[Selector Measure]
)
// You can hide the [Selector Measure]
// from the user's view and use the following
// instead. It'll do what the other does
// and also will summarize correctly unlike the other.
// You can also replace the [Selector Measure]
// with its body inside the new measure and
// then get rid of the old one completely.
// Up to you.
[Your New Measure] =
sumx(
values( 'Table'[Name] ),
[Selector Measure]
)
Thank your help. I appreciate the explanation!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 22 | |
| 10 | |
| 10 | |
| 7 | |
| 5 |