Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have direct query feed and relationships set between a table of entered data:
The filter for "site" works for all data except the measures in the table.
When i use it on a measure is shows this:
While it will work with columns I cannot write the same measure into a column, to caculate the average and ignore blank cells, not working, hence my earlier help request: Column Calculation Exclude Blank Cells - Microsoft Fabric Community
So the filter is working but will not work with a measure.
If I could find a solution to the filter issues, have tried many to one and many to many and single and both with no solution.
Or if i can work out the column calcualtion would work.
Thanks
Johnny
you cannot create meaningful columns from measures. The filter context is missing.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |