Search results

Don't think we could really help without knowing type of data held in your column(s) and table(s). One thing you could do, extract out each of VAR into another measure and return the value. Check data type of each. That could potentially identify data type mismatch. Note: SelectedVarClass...

If I understood it right... You just need OR condition. Filter any column, in the menu go to Advanced. Add all the columns and set it to >0 and OR for all column.

? That's not related to Power BI, Power Query... Don't think I'd be able to answer your question without more details.

I'd recommend going with Debaser's suggested method. My method is just for quick and dirty alternative. The reason you can't get filter to work is that you need to select the context on which to evaluate the value. Ex: If you need this filter to be set on User level. First select User as field...

Another, bit more convoluted method. Measure:= IF((Table1[Sum of Amount])>=15,1,0) Add to field. Apply custom number format to the measure. [>0]"Exceeded";[=0]"Not Exceeded" Then add value field filter.

1. Desktop is primarily for development and designing dashboard and model. Service is where semantic model and dashboard is published to. Where it can be shared with others and collaborate on reports. 2. Desktop is off line only. Service is online. 3. That depends on license. See point 1. 4...

I recently had a client approach me with request that involved sharing Power BI data with non-licensed users. The client did not have support from IT department and did not have budget for dedicated premium license. Initially recommended having multiple Power BI Pro license as cheaper...

Without the data model structure and bit of sample data, but hard to help. Though my guess, would be SUMX() that's your issue. SUMX is evaluated in each row context. From what I see in your screen shots. You don't need SUMX but just SUM([Recharge Value (Tiered) OLD])

In calculated columns, everything is evaluated based on row context. I'm assuming there's relationship between the table. Though without knowing your data set, and model. Bit hard for me to give you exact answer. Personally, I'd do this sort of calculation in DAX measure. But it will depend on...

You need to override filter context of the visual. Since it's segregated to "Aug" that's limiting the scope. You'll need to use ALL() and apply your condition using FILTER() function.

Typically speaking. You don't perform this sort of calculation in DAX column. What's your end goal?

PQ isn't the right tool. The site uses Ajax query once you navigate to venueUnitID URL. Ajax query URL is as following. "https://www.handball.no/AjaxData/SortedMatchesReservationsForVenue?fom=08.01.2024&tom=07.01.2025&id=4425&_=1725887420106" However, URL alone will not fetch the data...

Can you specify what you mean by "Heading"? If you mean visual title. You will need to overlay another visual (ex: Card visual) and use CONCATENATEX etc to construct measure to build string for title. See link for basic tutorial...

How are you using your measure? Context of DAX measure evaluation is critical in order for us to help you. But why do it in measure? That's column transformation type operation and best done in PQ stage. Not in data model using DAX. What is your end goal?

Try using Table.Buffer() to speed things up. Though mileage ma vary by machine spec. If wanting to do it in DAX either as calculated column or using measure. Have a read of link. https://www.sqlbi.com/articles/introducing-rankx-in-dax/

First extract month/monthname from date. Assuming it's actual Date type. =Date.Month([Date]) Select Custom, Group By, All Rows (No aggregation). Add custom column (Assuming original table is unsorted). =Table.AddIndexColumn(Table.Sort([Temp],{"Date", Order.Descending}), "Rank", 1) Remove all...

Load data to PQ. Then in the editor, select Plan Qtr & LE Qtr. Then unpivot. Load data to data model and make pivot table using data model as source. That's pretty much it.

You need to flatten data. Meaning Qtr data should be single column and another column for LE/Plan.

First, start by flattening out all your tables. But how is 1st table supposed to relate to the other 2? At any rate. Add custom column to Revenue & Expense after flattening it out. Change "Revenue" to "Expense" for Expense table. = Table.AddColumn(#"Renamed Columns", "Type", each "Revenue"...

There are tools to audit/evaluate your model, DAX pattern etc. SQLBI has many useful tools. https://daxstudio.org/ https://www.sqlbi.com/tools/bravo-for-power-bi/ https://www.sqlbi.com/tools/vertipaq-analyzer/ Other tools that I use are mostly for PowerBI Service or for Embedded. And doesn't...

This is forum for Power tool stack (Power Pivot, Power Query, Power BI etc). What you have is standard pivot table. You can't do that sort of Avg operation in traditional pivot. Source data granularity must match that of your Rows field. Meaning you need source data aggregated at daily level...

In your sample Sr. no 1 on either side isn't exact match. In PQ, text comparison is case sensitive. At any rate, see below for issue with your data set. Note that you can't mix FuzzyNestedJoin with regular join. Join type is defined at table level and not at column level. If it's inner join...

If they access via PowerBI desktop. That's not going to hide data from users. They will be able to see everything that's in the model. I'd recommend alternate approach. Such as leveraging Power Automate and Power Apps to serve data to the user.

It all depends on how underlying data is modeled and what fields belong to which table etc. Without data model, relationship and your actual measure(s), it's very difficult to give you help. I'd recommend uploading sample workbook that replicates your issue with desensitized data.

Go read up the link I gave you. It discusses in detail what caused this issue. As for difference between Fact vs Dimension tables... see links. https://builtin.com/articles/fact-table-vs-dimension-table https://learn.microsoft.com/en-us/power-bi/guidance/star-schema