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've connected a dataset from BI service and used BI Desktop report analyzer to create my dataset. When I try to create a parame ter using query designer I get this message: "Cannot find cube". An explaintion for what is going wron would be helpful.
you will need to share some more details, maybe the M code, screenshoots samples, the error code you getting etc, that help for people to be able to give a more exact response
Proud to be a Super User!
Thanks Stefano. Please see below
// DAX Query
DEFINE
VAR __ValueFilterDM1 =
FILTER(
KEEPFILTERS(
SUMMARIZECOLUMNS(
'Sales Entry'[Item No_],
'Prod No'[Prod No_],
'Sales Entry'[State],
'Sales Entry'[Variant Code],
Sales Entry'[Location Code],
"SumRemaining_Quantity", CALCULATE(SUM('Sales Entry'[Remaining Quantity]))
)
),
[SumRemaining_Quantity] > 0
)
VAR __DS0Core =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(
'Sales Entry'[Item No_],
'Prod No'[Prod No_],
'Sales Entry'[State],
'Sales Entry'[Variant Code],
'Sales Entry'[Location Code]
), "IsGrandTotalRowTotal"
),
__ValueFilterDM1,
"SumRemaining_Quantity", CALCULATE(SUM('Sales Entry'[Remaining Quantity]))
)
VAR __DS0PrimaryWindowed =
TOPN(
502,
__DS0Core,
[IsGrandTotalRowTotal],
0,
'Sales Entry'[Item No_],
1,
'Prod No'[Prod No_],
1,
'Sales Entry'[State],
1,
'Sales Entry'[Variant Code],
1,
'Sales Entry'[Location Code],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
'Prod No'[Prod No_]
Hi there, I am facing this same issue. Did you ever find an answer to it?
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.