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 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
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 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |