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 Experts
My current measure gives me the correct count of row
Solved! Go to Solution.
@Anonymous
Can you try this measure, need more explanation though.
Measure =
VAR __M = CALCULATE(COUNT('STG Fact_'[Actual_end_date]) ) RETURN
IF( _M = 5 , [Annual Value (£)] , BLANK() )
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Apologies I have not explained the question probably.. if the count measure gives 5, then the £ measure with count must give 16. Not the £ sign added to the count
Date | Value £ |
01/09/2020 | 3 |
02/09/2020 | 4 |
03/09/2020 | 2 |
04/09/2020 | 3 |
05/09/2020 | 4 |
5 | 16 |
@Anonymous
Can you try this measure, need more explanation though.
Measure =
VAR __M = CALCULATE(COUNT('STG Fact_'[Actual_end_date]) ) RETURN
IF( _M = 5 , [Annual Value (£)] , BLANK() )
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy
from my model,I can count the Agreement_ closed (Table B) which links to my fact table A - table C is the values Table. All tables are connect via Merchant_ID (primiary key) no direct relationship between Table B and C.
I can count the closed Agreement in Table B using
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |