dax

Hi , To achieve your requirement, you can try a measure with following expression: SLA % = CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] = "Breached" ) ) / CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] "No Target" ) ) Thanks, Xi Jin.

Yes, I have some Mode measures in the Quick Measures Gallery: https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Single-Column/m-p/359150 https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Multiple-Columns/m-p/359148

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to se

Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following example: Here we have the same …

This post describes approaches how to virtual relationships between tables can be established using the DAX function TREATAS() and also approaches how to create physical relationships instead.

Another Friday, another tip. Power BI has undergone a lot of innovative updates over the years, but my favorite one has been a combination of the cross-filtering & highlighting capabiliti…

Try this Column Max Date = VAR temp = { Table1[A Approved], Table1[B Approved], Table1[C Approved], Table1[D Approved] } RETURN MAXX ( temp, [Value] )

Hi This calculated table might be close. Table = VAR DistinctValues = SUMMARIZECOLUMNS('Table1'[Case],'Table1'[Team]) VAR Final = SUMMARIZECOLUMNS('Table1'[Case]) RETURN ADDCOLUMNS( Final , "Group" , CONCATENATEX( FILTER(DistinctValues,[Case]...

From Wikipedia on Covariance: https://en.wikipedia.org/wiki/Covariance In probability theory and statistics, covariance is a measure of the joint variability of two random variables.[1] If the greater values of one variable mainly correspond with the greater values of the other variable, and the sam...

This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand perform

Hi, I'm gaining a better appreciate for DAX and context. There is one topic that still has me a little puzzled. Appreciate some help to reaffirm my understanding (or corrections are welcome) and help with the bits I don't quite get yet... I think I understand what is happening in my calculate...

Hi Guys, I've Created a Graph in power bi that has the values on the y-axis, and the month number on the x-axis, something that looks similar to the below sample chart. Basically, what I need to do, is to find the "Prediction Grade" that most closely resembles the "Actual Value", and have the ...

Given a table of data called "Students" such as: Teacher Student Teacher A Student 1 Teacher A Student 2 Teacher A Student 3 Teacher A Student 4 Teacher B Student 1 Teacher B Student 5 Teacher B Student 7 Teacher B Student 8 Teacher C Student 3 Teacher C Student 4 Teacher C Student 7 Teacher C Stu...

I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection. I’m in finance, so my needs will almost always have a fina…

Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do this with variables!”. Variables are a great way…

Last week, I had the pleasure of recording some video with Bert Wagner about Power BI. In the video, I got to use one of my favorite analogies for M versus DAX: Are you chopping broccoli or planning a…

My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagn…

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop. In part 1 of this tutorial, I illustrated how to include more than one aggregation and cu...

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded

"I like big aggregations and I cannot lie You other PBI'ers can't deny" The attached PBIX file contains a slew of aggregations that span multiple columns All standard quick aggregations are included, namely: Max Min Sum Average Count Count (Distinct) Variance Standard Deviation Median This te...

Similar to Rolling Months, https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499 it is often handy to have the ability to do rolling weeks. For this to work, previous Quick Measures of Week Starting and Week Ending are required. https://community.powerbi.com/t5/Quick-...

Suppose you have some data like this: ID DimKey3 DimKey4 DimKey5 DimKey6 1 blue red green green 2 blue blue red blue 3 blue red blue blue 4 green green red green 5 green green blue green 6 red red red red 7 blue blue blue blue 8 green green green green 9 blu...

Builds off of First Working Day of Week here: https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Working-Day-of-Week/m-p/391332 Provides the same functionality for First/Last Working Day of the Week, Month, Quarter and Year as well as logical true/false tests for these. Included below a...

Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals…

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fine, it is fast and reliable and can be updated easily. B