Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I wonder if someone can help me with this as I have been working on it for a while with limited success!!
I am trying to write a measure to show how many courses an instructor has taught since their last assessment.
My columns are:
'Table1' [Last Instructor Check]
'Table2' [Total Courses] (a measured column combining 2 types of courses so not sure if table name needed)
The complication for me is that using this measure I need to create conditioning based on the [Instructor Risk Level] (contains values H, M, L)
Is this achievable in PowerBi?
Many thanks 🙂
Solved! Go to Solution.
Hi @CSJ123 ,
Please hvae a try.
Create a measure.
measure =
SWITCH (
TRUE (),
[Instructor Risk Level] = "L"
&& [Last Instructor Check] < 6, "Green",
[Instructor Risk Level] = "L"
&& [Last Instructor Check] = 6, "Red",
[Instructor Risk Level] = "M"
&& [Last Instructor Check] < 3, "Green",
[Instructor Risk Level] = "M"
&& [Last Instructor Check] = 3, "Red",
[Instructor Risk Level] = "H", "Red",
BLANK ()
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CSJ123 ,
Please hvae a try.
Create a measure.
measure =
SWITCH (
TRUE (),
[Instructor Risk Level] = "L"
&& [Last Instructor Check] < 6, "Green",
[Instructor Risk Level] = "L"
&& [Last Instructor Check] = 6, "Red",
[Instructor Risk Level] = "M"
&& [Last Instructor Check] < 3, "Green",
[Instructor Risk Level] = "M"
&& [Last Instructor Check] = 3, "Red",
[Instructor Risk Level] = "H", "Red",
BLANK ()
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |