Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Folks,
I am totally new to Power BI and I am struggling with my first dashboard
I have 5 columns that have multiple Text Inputs. I am attempting to count these inputs and display them on chart. I created a measure that enters a 1 if the correct text is present in the column. See below
Solved! Go to Solution.
Folks,
Thank you for the input.
I simply went back to the Query, added some Conditional Columns on the Text to get Numeric values.
I then created a measure in PowerBI to add the numbers nad got the correct result when entered into my reports
Thanks for the input and it is a pity I could not resolve with measures only
Folks,
Thank you for the input.
I simply went back to the Query, added some Conditional Columns on the Text to get Numeric values.
I then created a measure in PowerBI to add the numbers nad got the correct result when entered into my reports
Thanks for the input and it is a pity I could not resolve with measures only
HI @gerrymouse1,
It will help if you share some dummy data to test, it is hard to test without any detail same data.
How to Get Your Question Answered Quickly
In addition, you can also try to use the following measure formal if it meets for your requirement:
UAPPEHands_Filt_1 =
VAR smaCount =
COUNTROWS (
FILTER ( SMATAuditData, SMATAuditData[UnsafeAct1CategoryValue] = "PPE - Hands" )
)
VAR _table =
SUMMARIZE (
SMATAuditData,
SMATAuditData[UnsafeAct1CategoryValue],
"count", IF ( smaCount > 0, 1, 0 )
)
RETURN
SUMX ( _table, [count] )
Regards,
Xiaoxin Sheng
This did not work either gave me a different result.
Can you post a screenshot of your model and sample data of the relevant tables? (a test PBIX would be even better!)
Proud to be a Super User!
Paul on Linkedin.
Hey @gerrymouse1
Your field it likely set to aggregate by count or distinct count instead of sum. Check out the link below for more information on this: https://docs.microsoft.com/en-us/power-bi/service-aggregates
If this helps please kudo.
If this solves your problem please accept it as a solution.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |