Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Can some one help me to know for below syntax in Power BI measure
Count column A values if column B contains value=XYZ and if column c contains value= ABC or PQR
Solved! Go to Solution.
Just add a NOT to that part:
Measure = CALCULATE(COUNT(Table1[ColA]), Table1[ColB] ="XYZ", NOT Table1[ColC] IN {"ABC", "PCR"} )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Ramendra ,
Are the answer helpful for you? If yes, please kindly accept as solution. If you still need help, please share some sample data with us. Thanks.
@Ramendra , Try like
calculate(count(Table[ColumnA]), filter(Table, Table[column B] ="XYZ" && Table[column B] in {"ABC","PQR"}))
Hi @Ramendra
Measure = CALCULATE(COUNT(Table1[ColA]), Table1[ColB] ="XYZ", Table1[ColC] IN {"ABC", "PCR"} )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @AlB ,
Thanks for help.
Can you please also let me know what to mention instead of "IN" for Table1[ColC] IN {"ABC", "PCR"} ) if I want to apply like below for same syntax.
Table1[ColC] is not equal to "ABC" or "PCR"
Just add a NOT to that part:
Measure = CALCULATE(COUNT(Table1[ColA]), Table1[ColB] ="XYZ", NOT Table1[ColC] IN {"ABC", "PCR"} )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @AlB ,
Thanks for help.
Can you please also let me know what to mention instead of "IN" if I want to apply like below for "Table1[ColC] IN {"ABC", "PCR"} )"
Table1[ColC] does not equal to "ABC" or "PCR"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |