Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 66 | |
| 50 | |
| 45 |