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.
Hello Power BI Community
I'm trying to perform a SUM calculation which has multiple filters applied; however when needing to display the results in a table visual - it appears to be including all values including any that are blank? DAX measure is as follows:
Figure 2 is how I would like for it to be displayed.
Hi @diederd ,
We can try to put the measure into Visual Filter and set it greater than 0 if you do not want to show the row that feesPaidBuy is blank
Also we can try to disable "Show items with no data" for this measure.
Best regards,
Hello v-lid-msft
Thank you for your response; whilst I have tried the visual filter route (setting Fees Paid to is not blank) - this works within the PBI Desktop application, it's when this is published to a SharePoint webpart that the filter seems to disappear.
I'm somehow thinking I need to include this in the DAX query as to eliminate the blank values from displaying - just don't know how?
Thanks again for your help.
Hi @diederd ,
Sorry for late reply, Have you issue be resolved? Can you see the result of visual filter in Share point? Does the visual filter applied in Power BI Service?
Best regards,
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |