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 have data coming in from Microsoft Forms which is all non-numerical. I want to create alerts in Power BI when participants select particular options. Before I can set an alert the data must be numerical. How would I go about creating a measure that would be able to do this?
Solved! Go to Solution.
Hi @Dburnett ,
We can create measure to work on the text data. Such as
Measure = CALCULATE(COUNTROWS(table),FILTER(table,table[column]="text"))
And put it to card to make the alert work. If it doesn't meet your requirement, kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @Dburnett ,
Is your requirement is to convert the number which is in Text format to Numeric format?
If so, you can use VALUE dax function which Converts a text string that represents a number to a number in numeric data type.
VALUE ("5") -->returns 5.
Hi @Dburnett ,
We can create measure to work on the text data. Such as
Measure = CALCULATE(COUNTROWS(table),FILTER(table,table[column]="text"))
And put it to card to make the alert work. If it doesn't meet your requirement, kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |