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.
I was working long time in a dax and finally worked, eventhough I needed to modify that DAX to get another result but I cant make it work after several hours of trying.
The DAX it worked is this one:
Avg Total 2 =
VAR Months =
CALCULATE(COUNTROWS( ALLSELECTED ( PBI[Fecha],PBI[D_Laborales] )),PBI[D_Laborales]<>7)
RETURN
IF (
ISINSCOPE ( PBI[Fecha] ),
IF(SUM(PBI[Total])<>BLANK(),FORMAT(SUM( PBI[Total]),"0")),
DIVIDE (SUM ( PBI[Total]), (Months)))
This is the one is not working:
Avg Total 3 =
VAR Months =
CALCULATE(COUNTROWS( ALLSELECTED ( PBI[Fecha],PBI[D_Laborales] )),PBI[D_Laborales]<>7)
RETURN
VALUE(IF (
ISINSCOPE ( PBI[Fecha] ),
IF(SUM(PBI[Total])<>BLANK(),FORMAT(SUM ( PBI[Total] ),"0")),IF(
DIVIDE (SUM(PBI[Total]), Months )>0.5,1)))
This last DAX is trying to say that if the result is >0.5 Ineed 1, otherwise nothing but I cant sum that result.
This is the link if someone PRO wants to give me a hand: https://www.dropbox.com/sh/8l5immlieab1lnn/AAAYiih51EogoIi7m2UHrqXia?dl=0
Solved! Go to Solution.
Please try this expression in your measure. It references your existing measure and returns a result of 8. It basically recreates your table visual above in a virtual table and then sums up the virtual [Avg Total 3] column.
Avg Total 4 =
SUMX (
SUMMARIZE (
FILTER ( PBI, PBI[D_Laborales] <> 7 ),
PBI[DEMO],
PBI[CC],
PBI[MATRICULA],
'dotacion (2)'[APELLIDOS]
),
[Avg Total 3]
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this expression in your measure. It references your existing measure and returns a result of 8. It basically recreates your table visual above in a virtual table and then sums up the virtual [Avg Total 3] column.
Avg Total 4 =
SUMX (
SUMMARIZE (
FILTER ( PBI, PBI[D_Laborales] <> 7 ),
PBI[DEMO],
PBI[CC],
PBI[MATRICULA],
'dotacion (2)'[APELLIDOS]
),
[Avg Total 3]
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |