Forum Discussion
Helper IRFM Analysis Based on Year and Month Selection
The only change I made to my previous measure is shown below:
CALCULATETABLE(
'Invoice Header',
REMOVEFILTERS('Calendar'),
REMOVEFILTERS('Invoice Header')
)I used CALCULATETABLE to remove slicer filters so that the measure controls everything, not the visuals—and it worked.
Thank you.
Community SupportHi Abrar786 ,
Thanks for sharing the detailed measure and screenshots.
Your DAX logic for dynamic RFM scoring appears well-structured and should work correctly in isolation. However, since the visual isn’t returning the expected results, a few possible causes could be:
1. Filter Context Mismatch:
The measure builds a variable with Sub_Category, but if your visual uses 'Categories'[Sub_Category], there could be misalignment unless a proper relationship or matching context is established.
2. Missing Mappings in Lookup Tables:
If any RFM score (like 431, 555, etc.) doesn't exist in 'RFM Categories', the LOOKUPVALUE function will return blank. This causes those rows to be excluded from the final count.
3. Coverage Model Filtering:
If your selected Coverage Model from the slicer isn't present across all related tables, it may return zero rows during filtering.
If the issue still persists after trying the above steps, could you please share a sample of your data (no confidential info needed) to assist you better and reproduce this on our side.
This will help us validate the end-to-end logic and provide accurate guidance according to your model.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.
Helper IHi v-veshwara-msft ,
Here is the .pbix file.
Please note that the current results in the file are not correct. The expected output should match what is shown below.
https://drive.google.com/file/d/1dpKP-JffVUG5DFIF_aUcgV_ioOtSDeQg/view?usp=drive_link
Thank you.
- v-veshwara-msft
Hi Abrar786 ,
I’m unable to access the file and have submitted a request. Could you please approve the access?