cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shivagange
Frequent Visitor

Returns blank even though data is not there in that particular filter combination

Hi,

 

I have created a report that contain reviews data of Social Media.Here 3 sentiments are there (+ve review,-ve Review,Neutral Review) based on social media we are going to filter the reviews rating.For HolidayIQ there is no neutral reviews but in report it's showing blank instead of 0.I have tried many DAX commands but i didnt get any proper solutions for that.

 

Untitled.png

Would anyone have an idea how to do this?

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Shivagange
Frequent Visitor

Re: Returns blank even though data is not there in that particular filter combination

Hi@vcastello,

 

Thanks for your reply. I got the solution for this now its working fine.

ReeviewBlank = COUNTROWS ( FILTER ( review, TRUE() ) ) + 0

 

 

View solution in original post

2 REPLIES 2
vcastello Resolver III
Resolver III

Re: Returns blank even though data is not there in that particular filter combination

Hi @Shivagange

 

It returns (Blank), just because there is no data that fits the filter (Holiday IQ and Neutral).

 

You colud try something like this (assuming that your measure that counts the reviews is called [Measure M] ) ...

IF(ISBLANK([Measure M]), 0, [Measure M])


Shivagange
Frequent Visitor

Re: Returns blank even though data is not there in that particular filter combination

Hi@vcastello,

 

Thanks for your reply. I got the solution for this now its working fine.

ReeviewBlank = COUNTROWS ( FILTER ( review, TRUE() ) ) + 0

 

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors