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,
I'm new to Power BI and have a single excel spreadhseet.
I have the code for a filter which I used in a measure to get the number of expected rows and its comes through correctly.
The filtered code is in the format "FILTER(Database,Expression)"
I want to be able to make a calculated column for my data table where every row that is present in the Filtered datatable is shown as 1, else 0.
Th current code I used is:
Solved! Go to Solution.
@Anonymous , if you want to display data to reduce, you need to create a measure and use that in the table visual along with other columns
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@Anonymous , if you want to display data to reduce, you need to create a measure and use that in the table visual along with other columns
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks for replying, that solved my issue! To anyone else who does not want to show the measure (where measure is the Filter formula) next to the column table in the visual, you can also filter the data table based on the created measure and say 'if measure is equal to 1' and lock the filter.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |