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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Chanleakna123
Post Prodigy
Post Prodigy

Measure and Column Calculation

hi , i am not sure what happen here. 

 

between measure and column calculation aren't correct on the result ,i do comparison and it's wrong. well , Measure Calculation is right. 

Actually i wanna convert of Measure Calculation which is righ to Column table , because i wanna use Filter on Repurchased and No Repurchased . but measure calculation can't filter.

 

1.PNG2.PNG

3 REPLIES 3
adityavighne
Continued Contributor
Continued Contributor

create a new column and assign a measure

 

Column Name = measure

1.PNG

 

hi , it doesn't work , because "column 1" is calculated from column "Count on Purchased" , therefore , the result of "Column 1 " turns to No Repurchased , On table visuallization , even the Column"Count on Purchased" Counted as Total Count as per below. 

1.PNG

Hi , I mean even I put the calculation into table visualization , the column 1 still show the result no repurchased , despite the column count on purchased total the value together alr. The right thing is the column 1 will follow the column count on purchased. I also have filter on date. Therefore all the calculation will connect each other based on date filter

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.