Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The column total is incorrect in Matrix Visual. The month measure has 9 weeks. The weeks after w5 are filtered at visual level. The current total is calculated for all 9 weeks. I want to get the total for only 5 weeks in this visual. can you please help me to fix this?
Solved! Go to Solution.
I am getting memory issue if use sumx function. "There is not enough memory to complete the operation.
Hi, @Aruljoy
Based on your description, I create data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create two calculated columns and a measure as below.
Calculated column:
Month = FORMAT('Table'[Date],"mmm")
Weeknum = "W"&WEEKNUM('Table'[Date])
Measure:
Result =
IF(
ISINSCOPE('Table'[Weeknum]),
SUM('Table'[Value]),
CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Month] = SELECTEDVALUE('Table'[Month])))
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Aruljoy
Based on your description, I create data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create two calculated columns and a measure as below.
Calculated column:
Month = FORMAT('Table'[Date],"mmm")
Weeknum = "W"&WEEKNUM('Table'[Date])
Measure:
Result =
IF(
ISINSCOPE('Table'[Weeknum]),
SUM('Table'[Value]),
CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Month] = SELECTEDVALUE('Table'[Month])))
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Allan. This work for me.
Thanks for the response @az38 . But the value is already a measure.
I am getting memory issue if use sumx function. "There is not enough memory to complete the operation.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |