Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calulate a measure to sum the quantity of incidents where the text contains VFF.
The query i am using
Solved! Go to Solution.
Hi There,
DAX doesnt use Operators like SQL, it only recognizes the * as text.
try this:
New VFF = calculate (sum(Query1[QTY]), LEFT(Query1[Categorized_Disposition],3) = "VFF"
Hi @satish_pb ,
We can use the FIND() function to get the list of quantity of incidents where the text contains VFF, please refer to the following DAX query:
Measure = SUMX ( 'Table', IF ( FIND ( "VFF", 'Table'[Categorized_Disposition], 1, BLANK () ) = BLANK (), 0, 'Table'[QTY] ) )
The result will like below:
Best Regards,
Teige
Hi @satish_pb ,
We can use the FIND() function to get the list of quantity of incidents where the text contains VFF, please refer to the following DAX query:
Measure = SUMX ( 'Table', IF ( FIND ( "VFF", 'Table'[Categorized_Disposition], 1, BLANK () ) = BLANK (), 0, 'Table'[QTY] ) )
The result will like below:
Best Regards,
Teige
Hi There,
DAX doesnt use Operators like SQL, it only recognizes the * as text.
try this:
New VFF = calculate (sum(Query1[QTY]), LEFT(Query1[Categorized_Disposition],3) = "VFF"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |