Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Would anyone have an idea how to do this?
Thanks in advance!
Solved! Go to Solution.
Hi@vcastello,
Thanks for your reply. I got the solution for this now its working fine.
ReeviewBlank = COUNTROWS ( FILTER ( review, TRUE() ) ) + 0
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])
Hi@vcastello,
Thanks for your reply. I got the solution for this now its working fine.
ReeviewBlank = COUNTROWS ( FILTER ( review, TRUE() ) ) + 0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |