Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey everyone,
I'm struggling to understand how to create a measure for a gauge/KPI visual for my report, having an execution ID (snag on product) and case name (production units inspected).
I need to divide execution ID (for example 400) and disctinct count case name ( production units inspected, for example 10). To have a view of 40 snags per unit this month. But also to be able to filter them by last month (for example October for now, but later Novermber without updating the report, since it's for management, rather than having slicers for an analytical report). And also to apply a filter for severity (high, medium, low) to have three gauges/KPIs.
All these columns are in one table as a source.
Solved! Go to Solution.
Hi @tmyasoutov ,
maybe so
Measure = COALESCE(DIVIDE(COUNT(Table[Execution ID]),DISTINCTCOUNT('Table'[Case Name])),0)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tmyasoutov ,
try with this
Understood, thank you @mangaus1111 ! Any idea how to correctly add IF(ISBLANK) = 0 within this measure?
Hi @tmyasoutov ,
maybe so
Measure = COALESCE(DIVIDE(COUNT(Table[Execution ID]),DISTINCTCOUNT('Table'[Case Name])),0)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Execution ID | Case Name | Date | Severity |
44567 | 10010098 | 11.09.2022 | Low |
44568 | 10010098 | 11.09.2022 | Low |
44569 | 10010098 | 11.09.2022 | Low |
44570 | 10010098 | 11.09.2022 | Low |
44571 | 10010099 | 12.09.2022 | High |
44572 | 10010100 | 13.09.2022 | Medium |
44573 | 10010100 | 13.09.2022 | High |
44574 | 10010101 | 14.09.2022 | Medium |
44575 | 10010102 | 14.09.2022 | Medium |
Execution ID is an craftmanship error, Case Name is produced unit, date and severity. Count for Execution ID (10 in this case), distinct count for Case Name (5 in this case). I would like to show, that in September or other month, Execution ID/Case Name is 2 (in this case, as snag count per unit), but to filter that by month (preferably by current month) and by severity (like there were 2 High severity snags this month). Apologies for complicating this, not sure how to properly share information like this.
Hi,
Sorry, having trouble following, can you post sample data as text and expected output?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |