Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a calculated table that calculates the amount of time the expiry date changes per SKU.
Some of the matrix is blocked out for confidentiality purposes.
Thanks
Solved! Go to Solution.
Hi @obriaincian ,
According to your statement, I know that you have a hierachy level in your matrix visual. Is [...Segment] column in "Data" Table? I think you don't need to create a calculated table to aggregate value. Try to use virtual table in measure.
My Sample:
Measure:
Measure =
VAR _SUMMARIZE =
SUMMARIZE (
Data,
Data[Segment],
'Data'[Data.SKU],
"Change in Expiry Date",
CALCULATE (
DISTINCTCOUNT ( 'Data'[Data.Expiration Date] ),
'Data'[Expiration Date] <> BLANK ()
)
)
RETURN
SUMX(_SUMMARIZE,[Change in Expiry Date])
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @obriaincian ,
According to your statement, I know that you have a hierachy level in your matrix visual. Is [...Segment] column in "Data" Table? I think you don't need to create a calculated table to aggregate value. Try to use virtual table in measure.
My Sample:
Measure:
Measure =
VAR _SUMMARIZE =
SUMMARIZE (
Data,
Data[Segment],
'Data'[Data.SKU],
"Change in Expiry Date",
CALCULATE (
DISTINCTCOUNT ( 'Data'[Data.Expiration Date] ),
'Data'[Expiration Date] <> BLANK ()
)
)
RETURN
SUMX(_SUMMARIZE,[Change in Expiry Date])
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@obriaincian , if you created a table and displaying it, with some other tables. This new table should be joined with those tables. I doubt that here.
If this does not help
Can you share sample data and sample output in table format?
Hi @amitchandak ,
Thank you for your response, I can't merge the created table back to the original table as I have grouped SKUs in the table I created, can you please suggest how I might go about this?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |