Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I'm new to PowerBI and what I'm trying to do seems like it should be straightforward, but I can't figure it out. I have a table "Sheet1" that contains columns for "Process Owner" and "Control Frequency" amoung others, but these are the two I'm working with. I then created conditional column in the table named "Cycle Count" that has the following conditions "= Table.AddColumn(#"Changed Type1", "Cycle Count", each if [Control Frequency] = "Annual" then 1 else if [Control Frequency] = "Per Occurrence" then 1 else if [Control Frequency] = "Monthly" then 12 else if [Control Frequency] = "Quarterly" then 4 else null)"
In the visualizations I've created a table that has the Process Owner, Control Frequency, Count of Countrol frequency and the Cycle Count.
I then created a quick measure to multiply the Count of Control Frequency and Cycle Count columns.
And I end up with the following results:
I wasn't a math major, but I'm pretty certain that 1*12 <> 1, 10*4<>100 and so on. What am I doing wrong. Any assistance would be greatly appreciated.
Thanks in advance.
@PowerBINoob24 , Try a new measure like
Sumx(addcolumns(Summarize(Table, Table[Process Owner], Table[Control Frequency]), "_m1", calculate([Count of Countrol frequency]* [Cycle Count]) ), [_m1])
When I create that measure it tells me it cannot find the name Count of Control Frequency or the Cycle Count
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 49 | |
| 38 | |
| 31 | |
| 30 |