Forum Discussion
Percentage column issues
Disclaimer: I am new to power BI and currently trying to teach myself (2 days in) so please excuse and ignorance.
I have a table where I need to workout the adherence % using 2 columns, the issue I am facing is the columns in the data source are Text or blank values (Operating similar to the binary 1s and 0s). The table gathers all the records from a user and uses the count option to show the amounts. The issue I have is when I use Count of / total if gives me %s over 100, for example 2/2 will be 200% and so forth.
Columns from the data source:
Functions on the columns:
The table:
Is there any way to make the adherence formula use the visuals columns and not the data source as this works perfectly fine in excel.
Hi,
Thsose should be writen as measures (not as calculated columns). Also, replace the / with the DIVIDE() function.
3 Replies
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-Forum/ba-p/963216
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/1447523Hi,
Thsose should be writen as measures (not as calculated columns). Also, replace the / with the DIVIDE() function.
Hi,
Thsose should be writen as measures (not as calculated columns). Also, replace the / with the DIVIDE() function.
