Power Pivot showing all data with no values

[Tarek78210]

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 there is no budget or actuals (all the rows at -100%).

How can I stop showing all those empty rows showing -100%? If it is a genuine -100% (meaning there was a budget amount but no actuals), I want to show it. However, when there are no budget nor actuals, I don't want to show this in my pivot.

Thanks,

[Ashish_Mathur]

Hi,

This DAX pattern should work

Measure = if(and([Actual]=blank(),[Budget]=blank()),blank(),[your measure])

Hope this helps.

[Daniel29195]

@Tarek78210 

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! 🤠