issue with a simple DAX function using REMOVEFILTERS
Hi everyone, I’m experiencing an issue with a simple DAX function using REMOVEFILTERS, which behaves as expected when tested in a DAX query view (e.g., with summarizecolumns) but fails to clear filters when used in a table or matrix visual in Power BI Report Server Desktop (September 2024 release). Here are the details: I have a very basic measure that uses REMOVEFILTERS to clear specific filters on a column. While this works perfectly in the DAX query editor, the visual context (table/matrix) still applies the filters, ignoring REMOVEFILTERS. I also tried alternative functions like ALL and ALLSELECTED, but they do not work in the visual either.
Calculate difference between multiple columns and then highlighting the difference
Hello I am trying to calculate the difference between mutiple columns in PowerBI. And Highlight changes above and below 50 w/ color. I haven't been able to find any examples with multiple columns. I believe I have to create a measure but I'm not sure what calcualtions to use. Any help would be much appreciated.Loan amount to get updated same day next month
I have a one row per person with details related to his loan start and end date, repayment and installment amount information, what I want to get is the balance as on date. for example, Person A got loan of $100 on 6/9/2023 which has installement amount of $8 then every month 6th the value should get updated with $100 - $8 and the values should be repeating for slicer selection till next month 6th is encountered. Shown in the image below. The balance as on date is a measure and I have multiple tables and date dimension. I have tried different things nothing seems to work. I ideally want to count every 6th of the month as one month and calculate the balance amount as on date for that particular month. Which is becoming tricky. Please help. Ritaf1983 amitchandakSmart tooltip for Matrix rows
Hi Dear Community, I am trying to use a column from a table (which has 1:* relationship with the table from which I constracted my matrix) as a tooltip for my matrix rows. But I want my tooltip to show the particular value from that column which corresponds to the value of the row of the matrix I hover over. I wuold appreciate your help. Thank you in advance!
Need Dax Help Please!
Hi guys I have 2 tables. They are related through the Task column i need to write a calculated column that gives me a count of each task. Seems simple but the part that's tripping me up is if the task is task 3 or 4 then I need the count of those together in the calculated column. The one I wrote doesn't add them together. Here is an example table and my desired result. Thanks! Name Task John 1 John 1 John 2 Jim 1 Jim 2 Jane 1 Jane 2 Mike 3 Mike 4 Evan 3 Evan 4 desired result Task Calculated column count 1 4 2 3 3 4 4 4Count of Last 3 Months Unbilled outlets exclude the current Month
I have a column named "flag" in which "1" is against billed outlets and "0" is against unbilled outlets. I want to calculate the count of outlets that are unbilled from last 3 Months and exclude the current month. In full data: year_month range is January 2018 to Decemeber 2020. In Sample data provided for help: year_month range is 2020. Attached sample data image. Please guide me in using the DAX expression.
Power BI Mobile App to Power BI Server with OAuth + WAP: All reports return 404
Greetings, I have configured Power BI Server + OAuth + ADFS + WAP per https://github.com/MicrosoftDocs/powerbi-docs/blob/live/powerbi-docs/consumer/mobile/mobile-oauth-ssrs.md and https://www.youtube.com/embed/okzPAI2uUek. Using Power BI mobile app on Android and iOS, I can successfully authenticate. However, attempting to render any report just "spins" and if clicking refresh, returns 404. I have seen this error reported in a few other places, including: https://community.powerbi.com/t5/Report-Server/PBI-with-ADFS-and-WAP-i-can-authenticate-to-Server-but-all/m-p/367034#M4177 https://community.powerbi.com/t5/Report-Server/PowerBI-Mobile-App-and-Report-Server/m-p/397097 I have tried various combinations of changes to the WAP Application, the ADFS Application Group, and SPNs. When attempting to observe via Fiddler, I see the 404 returned on "GET https://FQDN/powerbi/mobile?manifest=OfflineSupport..." Not sure if that's helpful, or a red herring. I also noticed that there are some differences between the github docs and guyinacube's youtube video re ExternalURL and BackEndServerURL. Some examples include "/reports/" and some do not. I'm wondering if that could be related? Has anyone who has had this issue been successful in resolving? Any guidance greatly appreciated! GuyInACube ReiniervDijk agera111 Thanks, JN
