DAX Measure Based on Group and Range
Hello, I am attempting to write a DAX expression to assist in assigning a 1-5 value based on the performance of a representative, with 1 being "Far from Met" and 5 being "Significantly Surpassed." There are three different groupings: Alpha, Bravo, and Charlie. For example: So what I am looking to accomplish is assigning a 1 to 5 value based on the groupings illustrated above in one visual. I thought of this: IF('sheet name [Group] = "Alpha" && 'sheet name[Range] <425, 5 and so on for 4, 3, 2, 1 and repeat for the other two groups, however it's not working the way I thought it would. Any assistance would be greatly appreciated - if you have any additional questions, please let me know. Thanks, Andrew
Search In Different Order
I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter. Example Description Field: Pen Blue Medium Bic In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic" Thanks in advance for your help! 🙂 LaurindaMultiple slicers multiple selection not summing to the correct value
Hi, I have 2 different slicers each having different products; say Slicer 1 has 3 products-A, B, C, and Slicer 2 has 3 products-D, E, F. When I am selecting All values from both slicers it's giving me a correct cumulative added value in the card. But if I select any 1 or more values (but not all), the card value gets adjusted only to one slicer and doesn't give value summing up the selected values of both the slicer. Can someone please help me with this? calculate('Metrics'[Revenue], filter('Product',Product'[Product X]in {"A","B","C","D","E","F"}),FILTER('Calender','Calendar'[Quarter] in {2020Q1,2020Q2})) . This is my table: A 10 B 20 C 5 D 5 E 25 F 35 This gives correct no. in the card 100 100 Slicer 1 Slicer 2 All All This gives wrong value, it should give 110, instead, it's giving only 10 10 Slicer 1 Slicer 2 A AllRepeat Visuals Per Employee in Report
Is there away to repeat the same visualizations per employee in Power BI report? As an example, when the end user selects a department from a slicer, the employee list would change, but each employee would have the same set of 5 or so visualizations. Has anyone accomplished this if so how?
