Forum Discussion

gerrymouse1's avatar
gerrymouse1
Frequent Visitor
6 years ago
Solved

Getting Wrong Totals With Measure

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 cha...
Need Help
  • gerrymouse1's avatar
    gerrymouse1
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • gerrymouse1's avatar
    gerrymouse1
    Frequent Visitor
    6 years ago

    This did not work either gave me a different result.