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.
Hi guys,
I'm having problem rounding numbers to more readable digits and struggle with the formatting.
Here is the original function before I tried to round it
Measure = SWITCH(TRUE(), MAX(Table2[Category]) = "Value", CALCULATE(SUM(Table1[Amount]),
FILTER(Table1,SEARCH("(25%) - (10%)",[Percent],1,0))))
Here is my function that I modified but I received an error
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Measure = SWITCH(TRUE(), MAX(Table2[Category]) = "Value", ROUND(CALCULATE(SUM(Table1[Amount]) / 1000),
FILTER(Table1,SEARCH("25% - 10%",[Percent],1,0) )))
I would like it to display $747 with the currency sign (Is there a function I can write to display the currency beside using the Modeling ribbon?) and I would like the numbers display in the Table visualization and not in the Card visualization.
Thank you all 🙂
Solved! Go to Solution.
I must say I don't really get what you're trying to achieve, so not sure how to help you
in general you can use format in the following way:
Formatted Measure = FORMAT ( [Measure], "$#,##0" )
you can use FORMAT to do that
https://msdn.microsoft.com/en-gb/query-bi/dax/format-function-dax
I must say I don't really get what you're trying to achieve, so not sure how to help you
in general you can use format in the following way:
Formatted Measure = FORMAT ( [Measure], "$#,##0" )
Thank you for the tips.
This is how I wrote my measure
Measure = SWITCH(TRUE(), MAX(Table1[ID]) = "ABC", FORMAT([Count of ID],"#,##0")
MAX(Table1[Account]) = "ACC",
FORMAT([Count of Account],"$#,,"))
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |