Forum Discussion
Power Pivot showing all data with no values
Hi All, The image below is showing the actual revenue and budgeted revenue per customer (variance in € and in %). For some reasons, the pivot table is showing the list of all customers even if t...
Daniel29195
Community Champion
Community Champion
if column H is a measure called measure_h and second measure called actuals /
measure_h =
//code here
var variance= code here
return
if( isblank([actual]) , blank() , variance )
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠