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 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?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |