Forum Discussion

gaurav1991's avatar
gaurav1991
Regular Visitor
9 years ago

Need Help!

I have a query. Please help!   I have 2 columns (X and Y) with 10 rows each.   1. In X column top 4 rows are blank and rest 6 rows have values. "X" Column Values: [Blank, Blank, Blank, Blank,...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi gaurav1991,

 

How about this formula, which is created for the scenario you depicted?

 

XYZ =
VAR total =
    CALCULATE ( COUNT ( Table31[X] ) + COUNT ( Table31[Y] ) )
RETURN
    IF ( ISBLANK ( total ), 0, total )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi gaurav1991,

 

Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.

Best Regards!
Dale