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.
HI again,
Why a second virtual table with Crossjoin show back a blank value when I previously removed in a previous virtual table?
First virtual table( the blank value is not show up here):
SUMMARIZECOLUMNS (
Data[ProductG],
CALCULATETABLE ( Data, Data[ProductG] <> BLANK () )
)
I also try
SUMMARIZECOLUMNS(Data[ProductG], filter(data,Data[ProductG]<>blank()))
Second virtual table(but it is back the blank value for ProductG column):
Table.Bridge.v2 =
VAR progenerationV =
CROSSJOIN ( ROW ( "Type", "ProductG" ),
VALUES ( 'TBL.ProductG'[ProductG] ) )
VAR bregionV =
CROSSJOIN ( ROW ( "Type", "Region" ),
VALUES('TBL.BRegion') )
RETURN
union(progenerationV ,bregionV )
Thanks in advance...
Hi @perezco
Crossjoin function would return a table that contains the Cartesian product of all rows from all tables in the arguments.
So the blank value also shows in your result.
Please show some example data and expected result, i'm willing to work out this problem.
Best Regards
Maggie
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |