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...
Ashish_Mathur
Super User
Super UserHi,
This DAX pattern should work
Measure = if(and([Actual]=blank(),[Budget]=blank()),blank(),[your measure])
Hope this helps.