misiek5510
New Member
- Joined
- May 25, 2021
- Messages
- 38
- Office Version
- 2016
- Platform
- Windows
- Mobile
Hi,
In data view I added new column Col1 that is an if statement which gives either yes or no.
In report view I have a table which basically has 100s of rows with multiple columns with one being the Col1 (yes or no column).
I'm now trying to count how many YES and how many NO's there is, as separate measures however no measure formula is working for this!
Example:
Yes = CALCULATE ( COUNT ( Table1[Col1] ), Table1[Col1] = "Yes" ) For example this formula will not work as it won't find the bit in red and all formulas I find online work the same way!.
Help
In data view I added new column Col1 that is an if statement which gives either yes or no.
In report view I have a table which basically has 100s of rows with multiple columns with one being the Col1 (yes or no column).
I'm now trying to count how many YES and how many NO's there is, as separate measures however no measure formula is working for this!
Example:
Yes = CALCULATE ( COUNT ( Table1[Col1] ), Table1[Col1] = "Yes" ) For example this formula will not work as it won't find the bit in red and all formulas I find online work the same way!.
Help
