Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am working with Direct Query and there is a measure in table visual and that same measure is used as visual level filter in table visual. I know there is a limitation in direct query to use measure as filter.
First of all my dim column is coming from field parameter, but for testing I removed it and picked directly column from a dim table and wrote this measure
@Seek08 , This need to executed at line level or level based on common dim
Sumx(Table, [KPI1]*[KPI2])
or
SumX(Values(Dim[Category]), [KPI1]*[KPI2])
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |