The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I want to create a measure to calculate the number of IDs (DISTINCTCOUNT(ID) which meet some condition and the number of transitions of those ID are greater than 3.
Conditions are:
Historico[Anomalia3] = "Anomalia3"&&Historico[EmpresaSopInicial] ="ViewNext"&&Historico[EstadoInicial] <> "Resolved"&&Historico[EmpresaSopFinal] ="VN"&&Historico[EstadoFinal] = "Assigned")
I have tried with the following measure:
Solved! Go to Solution.
Hi @Ley ,
Please update your formula like that.
Measure =
VAR dis =
CALCULATE (
DISTINCTCOUNT ( Historico[ID de incidencia] ),
FILTER (
Historico,
Historico[Anomalia3] = "Anomalia3"
&& Historico[EmpresaSopInicial] = "ViewNext"
)
)
RETURN
CALCULATE ( COUNTROWS ( Historico ), FILTER ( Historico, dis > 3 ) )
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi,
I have tryed your formula and it does not work. I want a distinctcount of ID when the number of rows associated with this ID that meet the conditions are superior to 3. I have tried the following modification of your formula, but I am not sure if it is right.
Thanks in advance
Hi @Ley ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @Ley ,
Please update your formula like that.
Measure =
VAR dis =
CALCULATE (
DISTINCTCOUNT ( Historico[ID de incidencia] ),
FILTER (
Historico,
Historico[Anomalia3] = "Anomalia3"
&& Historico[EmpresaSopInicial] = "ViewNext"
)
)
RETURN
CALCULATE ( COUNTROWS ( Historico ), FILTER ( Historico, dis > 3 ) )
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi,
I have tryed your formula and it does not work. I want a distinctcount of ID when the number of rows associated with this ID that meet the conditions are superior to 3. I have tried the following modification of your formula, but I am not sure if it is right.
Thanks in advance
Hi @Ley ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |