Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AnneMi
Frequent Visitor

Countif with multiple criteria

Hi, 

I want to make a measure to count how many uniqe "Numbers" That has a value from the colon: "Special" 

 

AnneMi_0-1670923360788.png

AnneMi_1-1670923396834.png

 

 

1 ACCEPTED SOLUTION
JamesRobson
Resolver II
Resolver II

Hi,

 

 Quick solution would be to Pivot the Special and Number columns using a count not blank? Not sure if you have a specific layout required post count or not.

JamesRobson_0-1670924703150.png

 

 

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Number", Int64.Type}, {"Special", Int64.Type}}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Number", type text}}, "en-GB"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Number", type text}}, "en-GB")[Number]), "Number", "Special", List.NonNullCount)
in
#"Pivoted Column"

 

Thanks,

View solution in original post

1 REPLY 1
JamesRobson
Resolver II
Resolver II

Hi,

 

 Quick solution would be to Pivot the Special and Number columns using a count not blank? Not sure if you have a specific layout required post count or not.

JamesRobson_0-1670924703150.png

 

 

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Number", Int64.Type}, {"Special", Int64.Type}}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Number", type text}}, "en-GB"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Number", type text}}, "en-GB")[Number]), "Number", "Special", List.NonNullCount)
in
#"Pivoted Column"

 

Thanks,

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors