Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Currently, I have next measure which gives the expected result for the rows 1801.00 and 0801.00:
"Formula 1"
Solved! Go to Solution.
As per need create the that cloumn as measure:
Measure=sum(Project budget lines'[Cost line])
Later
Measure 1= if(Measure in condtion, Formula1, Formula2)
Create a measure as given below:
Measure= if(Project budget lines'[Cost line] IN {"1801.00","0801.00"},Formula1,Formula2)
Hi,
thanks, makes sense, however I cannot select/set the Table field (Project budget lines'[Cost line] ) in the measure. It's only coming up with other measures, and not with table values?
As per need create the that cloumn as measure:
Measure=sum(Project budget lines'[Cost line])
Later
Measure 1= if(Measure in condtion, Formula1, Formula2)
Thanks for your help. Solved!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |