Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |