Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am new to power bi,Actually i want to divide BL with TBL to get thier ratio,but it give me only one vlaue for the first row,I want the function that resuilt for all row.
Solved! Go to Solution.
Thanks @PowerBigginer
Hi, @zia1991
Based on the data provided by your picture, I guess your BL and TBL are both a metric, so I created the following sample data:
I created two measures and placed them in the table visual:
I use the following DAX to divide each row:
MEASURE =
VAR _seletedvalue =
CALCULATE ( [TBL1], ALL ( 'Table' ) )
RETURN
DIVIDE ( [BL1], _seletedvalue, 0 )
Here are the results:
I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @PowerBigginer
Hi, @zia1991
Based on the data provided by your picture, I guess your BL and TBL are both a metric, so I created the following sample data:
I created two measures and placed them in the table visual:
I use the following DAX to divide each row:
MEASURE =
VAR _seletedvalue =
CALCULATE ( [TBL1], ALL ( 'Table' ) )
RETURN
DIVIDE ( [BL1], _seletedvalue, 0 )
Here are the results:
I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
But you don't have any values in TBL If you don't have values you can replace with 0
Try this = DIVIDE([BL],[TBL],0)
For more Power BI tips and Tricks https://powertipstricks.blogspot.com/ check out the blog
If it works Please Mark As A solution !
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |