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.
My question is for a question focused on a didactic example. I retrieved the table below with the measurement shown below. I am using Dax Studio for this example.
EVALUATE
ADDCOLUMNS (
SUMMARIZE (
CALCULATETABLE ( fSales, KEEPFILTERS ( dCompany[ID] = 5 ) ),
[groupProduct],
"totalSales", [totalSalesInPeriod]
),
"totalSales_v1", [totalSalesInPeriod]
)
The totalSales column returned with the correct values for each group. The totalSales_v2 column returned without any filter.
Well, what should have happened is that in the SUMMARIZE it should be for the group and the company ID while in the second, it should just be the group without the company id. You would need to implement the filter for the second one to have both the same. And I would just use FILTER and not KEEPFILTER that seems way more intuitive to me. But, that's just one opinion.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |