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 all,
I have two tables like :
How can I do this mutiplication :
Also if any value is empty or 0 , how can it displayed as 0 here?
Can someone explain this with help of both Measures / Custom column?
Update :
I am able to Create a Custom table like below and I can get below results, but this seems takes lot of data. can anyone help me for a creating custom measure ?
Custom Table :
@Anonymous Seems like you would want to create a measure for this, not sure where the 6 is coming from. You could use LOOKUPVALUE or just MAX if the tables are related. In that measure, you could ensure that you get zeros as well doing something like:
Measure =
VAR __Calc = <some calculation>
RETURN
IF(ISBLANK(__Calc),0,__Calc)
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 |
---|---|
107 | |
98 | |
78 | |
64 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |