cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Simple Calculation Blows Up Table Visualization

I created a simple table visualization with 57 rows of data. I'm trying to perform a simple calculation with a new measure, calculate(100-sum(price)) but when I do, the table explodes into 1000s of records, majority of this new measure being 100. I'm assuming the calculation is performing on the blank rows.  How do I prevent it from calculating on the blank rows and to just perform the calculation on the original 57 rows of data?

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

I am not sure how you created your measure for 57 rows in table visualization, but please try something like the below.

 

New measure =
IF (
[your measure that created 57 rows] <> BLANK (),
100 - [your measure that created 57 rows]
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
gdarakji
Resolver III
Resolver III

It can also be that the fields in the table and the ones used in the measure are not related properly in the model. This will result in a cross join between all used tables and thus the thousands of rows you are getting.

Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

I am not sure how you created your measure for 57 rows in table visualization, but please try something like the below.

 

New measure =
IF (
[your measure that created 57 rows] <> BLANK (),
100 - [your measure that created 57 rows]
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!