Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
zia1991
New Member

divide function

zia1991_0-1713425174792.png

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.

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

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:

vjianpengmsft_0-1713489451108.png

I created two measures and placed them in the table visual:

vjianpengmsft_1-1713490026792.png

vjianpengmsft_2-1713490039980.png

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:

vjianpengmsft_3-1713490163451.png

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.

 

 

 

 

View solution in original post

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

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:

vjianpengmsft_0-1713489451108.png

I created two measures and placed them in the table visual:

vjianpengmsft_1-1713490026792.png

vjianpengmsft_2-1713490039980.png

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:

vjianpengmsft_3-1713490163451.png

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.

 

 

 

 

PowerBigginer
Helper II
Helper II

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 !

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.