Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Good morning, I am creating a report that looks like the following;
My problem is with the "Type" field that is grouped
As you can see, the "Check" field gives me an error, in that field I would like to obtain the same values that are in the "P" column, which, as I said, is a grouped column called "Type"
The idea is to count all the "BaleID" where "Type" is equal to "P", I have tried the following expressions and I get an error, I can't think of how to achieve it.
=Count(Filter(Fields!Type.Value,"P",True, Fields!BaleID.Value))
=Filter(Count(Fields!BaleID.Value),Fields!Type.Value="P",True,CompareMethod.Binary)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |