Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to select values from table in Power BI based on some conditions. When I create a new measure and use Evaluate it shows error. Could some one help me out. Here I need to get values in Calculated Column where ColumnName is some X.
@SpartaBI @truptis @Ashish_Mathur
Solved! Go to Solution.
@Anonymous here is a link to a file with a solution example I made for this question:
Select query in power BI.pbix
@Anonymous you can't use EVALUATE in measures / calculated columns or in general inside Power BI. It's only for queries. Can you share what exactly you want to achieve and I'll share the code with you
I need the Values in Calculated column based on condition where ColumnName value =HighVoltage_Calculated. So as to visualize as a line chart
@Anonymous still not sure I understand 🙂 Can you share a sample data and hard code there the result and write the logic behind it?
Thank you for responding 🙂 . This is the data sample. The field ColumnName has several other entries too. I need to plot the Calculated values against time with condition as ColumnName entries.
@Anonymous will PM you now 🙂
@Anonymous here is a link to a file with a solution example I made for this question:
Select query in power BI.pbix
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |