topic Re: Hello, can you help me with this dax measure: in DAX Commands and Tips

Hello, can you help me with this dax measure:

JpTueros — Tue, 25 Jun 2024 16:17:13 GMT

VAR MiTabla =
CALCULATETABLE(
ADDCOLUMNS(
SUMMARIZE(
Stage_DetalleNotaAlumno,
Stage_DetalleNotaAlumno[CodAlumnoPS]
),
"Nota1", [Nota_NA],
"FiltroNota", [Nota_NA] >= 12
)
)
VAR Resultado =
CALCULATE(
COUNTROWS( MiTabla ),
MiTabla[Nota1] >= 12
)
RETURN
Resultado

Re: Hello, can you help me with this dax measure:

Greg_Deckler — Tue, 25 Jun 2024 16:21:53 GMT

JpTueros Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Hello, can you help me with this dax measure:

jptd — Tue, 25 Jun 2024 17:08:09 GMT

Hello:

I have this table as a Variable, and then I want to count rows when Nota1 >= 12

Stage_DetalleNotaAlumno[CodAlumnoPS]	Nota1
1774687	22.6666667
1708851
1734135
1773797	29
1779116	26
1779256	28
1779264
1779362
1779390	20.6666667
1779428
1779437	30.6666667
1777184
1777307
1777497	24
1777556	34
1777602	36
1777721
1778995
1779004	13
1776864	34
1777010
1775297
1776023	10
1776686
1489753	16
1616732	20

Re: Hello, can you help me with this dax measure:

Anonymous — Thu, 27 Jun 2024 08:18:01 GMT

Thanks for the reply from Greg_Deckler , please allow me to provide another insight:

Hi JpTueros ,

You can try the following measure:

Measure = var MiTabla= SUMMARIZE( ALL('Stage_DetalleNotaAlumno'),[CodAlumnoPS],"Note",[Nota_NA]) return COUNTX( FILTER(MiTabla, [Note] >=12),[CodAlumnoPS])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.