DAX "New Measure" for AVERAGE of slicer value
I'm new to Power BI and DAX. I have this "New Measure" that works correctly for the total % of items worked in the table. Goal = AVERAGE('Distribution'[% Items Worked]) I need to know how to change this to show % of items worked based on slicer filters. I tried using ALLSELECTED, but I must not be writing the command correctly. Please help.RANKX when “Product” appears on multiple rows?
How do I get RANKX to work on filtered data source where same product appears on multiple rows? In this Excel example, the data loads easily into a pivot table for the desired result. As you can see, Banana ranked #2 in the WEST, but #3 in the EAST. What am I missing in my RANKX calculated measure? $ RANK = RANKX(ALLSELECTED(ItemRANK[Product]), SUM(ItemRANK[Dol$ Sales]), ,DESC) I want to be able to filter on different Time Period, different Geography, different Brands and rank to change based on slicer/filtering. Thanks.
IF help needed - new measure
Hi all, Power BI newb here despearatly trying to get my head roudn all this. Trying to rebuild Excel sales report in PowerBI but there are a few manual calculations I'm struggling with and I'm hoping someone can help... Please! - a calculation is needed that does "quantity"*-1805 IF column "x" is populated with a "Y" BUT not if the first 4 characters of the column "itemnumber" are "DISC", in which case no deduction should be made. Any guidance here most welcome Thanks R
Calculate Student Journey
So I need to show student journey - find the number of student completed all the course in each month. There are 2 tables. 1) Courses details(Course master) Columns(ID, CourseName) 1-CourseA, 2-CourseB ...5-CourseE. 5 courses total. 2) Transaction Table. Having details StudentId, CourseID, CompletedDate(DateTimeStamp) etc. Lets say Student1 completed 2 courses(A and B) in May, 1 course(D) in June, 1 course(C) in July and 1 course(E) in Aug. Student Journey is completed in August. Total student are 500, some will complete all 5 course in May, some in June etc. Sample Data Screenshot for expected result Any help is appreciated
