Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a table visual which returns contractor names based on a number of slicer selections and a card visual 'Total Technicians' which showed the measure TotTechs = COUNT(DimContractor[Id]) both matched fine until...
@Richard_Halsall , measure is calculated run time. Means any grouping you need to compare need to forced
example, force calculation at status level
Course_ANDOR_Check = Sumx(values(DimCerts[status]),
IF(
[Selected_counter] = 0,
1,
IF(
DISTINCTCOUNT(DimCerts[Name]) = [Selected_counter],
1,
[Selected_AndOr]
)
))
@amitchandak Hi thanks for the speedy response I have tried your solution and what it actually gives me is the count of selected values in the slicer.
What I would like is the count of the records returned in the table visual which shows contractor IDs meeting the criteria for selected value 1 AND value 2 in the slicer 'Name'
In the screenshot shown I have selected 2 values in the slicer 'Name' which has correctly given me 5 records in the table e.g. 5 contractor id records
but the card visual shows 643 which is a count of the records for contractor id's relating to value 1 OR value 2 in the slicer 'Name'
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |